List Dates in Column A1

Closed
Report
Posts
1
Registration date
Monday October 7, 2013
Status
Member
Last seen
October 7, 2013
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
In column A1 i need dates lets say 1-Nov-13 numbering for an entire year.

The tricky part is i need Cell A1,2,3,4 to have the same date. 1-Nov13. then cells A4,5,6,7 to be 2-Nov-13. and so on and so forth for an entire calender year.

I have done 30 days with this function. =$A$(whatever cell #)+1. and i would change the cell number as i went along. I did 30 days of this for November and decided there had to be a better way.

please help!

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi It_ac_woods,

Try this:
A1: 41579
A2: 41579.25

Drag these two cells down as far as desired and change format to date.

This basically adds time to the date.

If you don't want that because of further calculations use another (temporary) column and use the INT formula as in:
=INT(A1)

Best regards,
Trowa