| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy date formula to multiple sheets
I am trying to setup a workbook with 52 sheets (1 per week). I put 11/18/06
in sheet1!a1, then goto sheet2!a1 and enter the formula +sheet1!a1+7. The result is 11/25/06. But when I copy sheet2!a1 to sheet3!a1, the result is still 11/25/06, it should be 12/02/06. -- John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum by date rage using multiple sheets | Excel Discussion (Misc queries) | |||
| How do I copy a reference formula onto multiple worksheets | Excel Worksheet Functions | |||
| How to copy and paste same formula in multiple cells? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How do I protect formula cells on multiple sheets? | Excel Worksheet Functions | |||
Threaded Mode
