Forum Discussion
list of sequential dates increasing by 7 days
Hi... Im trying to create an auto-filled series of sequential date headings that increase by one week. Cant see how to do this? Thanks!
Charrrrlotte As a variant, if you have Excel for MS365 or 2021 you could try this:
=SEQUENCE(,52,DATE(2022,1,1),7)Format the dynamic array it produces as Date in the preferred style. The number 52 would create 52 weekly values. Use more or fewer as needed.
- Thanks - I can only see it says I have version16.61.1 so I'm not sure?
Charrrrlotte So you don't see something like this?
- Yes thanks- but I was wondering if I could use the edit...fill... series... type thing. Also - I cant seem to get it to recognise the date formatting at the moment so even the +7 isnt working as I just get an error msge!
Maybe like this. I selected Home->Fill->Fill Series and entered the criteria shown in the picture.
