software

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 quot;want to copyquot; 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

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