If your formula in sheet 3 is saying sheet1!a1+7, that will still be
11/25/06.
--
David Biddulph

"John" wrote in message
...
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