A1 has a date.

In A2 enter =A1 + 7

Copy down.


Gord Dibben MS Excel MVP

On Sat, 12 Sep 2009 17:22:01 -0700, Yan
wrote:

Hi!

I have this Darts Stats sheet that i am doing, the sheet is alwyas the same
except that the name of the sheet changes every week with the actual day
dates.......

And, on my master sheets, i made the 1st value lookup with absolute value
and the onjly thing i need to do when copying the cell down i want the cell
to just change the date automatically......in increment of 7......thank you!