List Dates in Column A1

Closed
lt_ac_woods Posts 1 Registration date Monday October 7, 2013 Status Member Last seen October 7, 2013 - Oct 7, 2013 at 08:33 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Oct 7, 2013 at 11:49 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Oct 7, 2013 at 11:49 AM
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

0