Date formula that adds 7 days to a cell when sheet is copied

[dkent]

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.

[Bernard Liengme]

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" <dkent@discussions.microsoft.com> wrote in message
news:4CB4B8C7-0805-4A61-994B-56A72C7B795E@microsoft.com...
>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.