List Dates in Column A1

[Closed]
Report
Posts
1
Registration date
Monday October 7, 2013
Status
Member
Last seen
October 7, 2013
-
Posts
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 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
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 2021
470
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!