Previous Topic Next Topic

List Dates in Column A1

Closed
lt_ac_woods Posts 1 Registration date Monday 7 October 2013 Status Member Last seen 7 October 2013 - 7 Oct 2013 à 08:33
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 7 Oct 2013 à 11:49
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 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
7 Oct 2013 à 11:49
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

Similar discussions

lava hard reset & factory reset
AVAY -
Har -

3 responses
Lava A1 Brand reset
Anil123 -
Ambucias -

1 response
How to format Lava mobile?
Akum -
Dushyant -

22 responses
Snapchat block list
Jasonve -
dwebb -

1 response
Blocked account list shuffled without me unblocking or blocking
Besmir85 -
Ec92 -

6 responses