list of sequential dates increasing by 7 days

[Charrrrlotte]

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!

[#2]

@Charrrrlotte 

=A1+7

Is this what you want to do?

 

[#3]

@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.

[#4]

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!

[#5]

Thanks - I can only see it says I have version16.61.1 so I'm not sure?

[#6]

@Charrrrlotte So you don't see something like this?

[#7]

@Charrrrlotte 

Maybe like this. I selected Home->Fill->Fill Series and entered the criteria shown in the picture.

[#8]

...I see this...

 

@Riny_van_Eekelen 

[#9]

Yes!! That's it! Where you have 'inkrement' I have 'step' which didn't make sense to me - 'increment' would have been much clearer!!! I have now put a 7 in & it works! Thanks!!