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?