[Solved] Excel Add date column with dates repeated 24 times [duplicate]

by


Suppose your Hours starts from A2. Then you can write in date column (column C):

=DATE(2013,1,1)+INT(A2/24)

and drop it down.
Next step, write in month column (Column D):

=MONTH(C2)

and drop it down.

3

solved Excel Add date column with dates repeated 24 times [duplicate]