Solved Date increase by week

May 5, 2013 at 15:02:25
Specs: Windows 7
How do I make the date increase weekly instead of daily, when I type the date in a cell then drag it to the bottom the date increases daily but I want this to change each row to weekly, i.e I want 02/09/2003 to become 09/09/2003 in the next row instead of 03/09/2003

See More: Date increase by week

Report •

May 5, 2013 at 15:14:52
✔ Best Answer
If the starting date was in A1, in A2, type:
=A1 + 7

How To Ask Questions The Smart Way

Report •
Related Solutions

Ask Question