Hi Mark,
If you input the starting date in A1, then the formula =A1+7 in B1, you can copy that formula/cell across as far as needed. Each cell's date will be 1 week greater than that of the cell before it. Change the date in A1 and the date in all the other cells will change too.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|