Office '07



Without spreadsheet knowledge heroics--

Is there a reasonably easy way to create on a single row a date defined start and finish with the intervening cells representing the consecutive weeks between the start and finish?

Thanks,

Mark

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]

Thanks Paul!

Mark