I am triying to create a formula that will insert a date based on a date that
is one week later. I want it to create a date when I copy a sheet and create
a new sheet in the same workbook. For example in sheet 1 I have the date
3/1/06, I want to copy this sheet and have the date in sheet 2 to be 3/8/06
etc.

If there is a date in A1 of Sheet1, then in an cell in Sheet2 the formula
=Sheet1!A1+7 will return a data seven days later.

But you "want to copy" Sheet1 to Sheet2? Please clarify. Do you want to copy
a range from one sheet to another AND at the same time have dates
incremented by 7?

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dkent" wrote in message
...
I am triying to create a formula that will insert a date based on a date
that
is one week later. I want it to create a date when I copy a sheet and
create
a new sheet in the same workbook. For example in sheet 1 I have the date
3/1/06, I want to copy this sheet and have the date in sheet 2 to be
3/8/06
etc.