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