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

D

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.
 
B

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
 
Top