| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date formula that adds 7 days to a cell when sheet is copied
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
| How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Threaded Mode
