format multible worksheets in a workbook

[Guest]

I need to know how to format worksheets in a workbook and have them reconize "3-d" cell references.
i.e. cell a1 on sheet 1 is todays date, need to have cell a1 on sheet 2 read the date 7 days later, sheet 3 another 7 days etc.

All attempts to do this on the additional sheets keeps referencing sheet 1.

Thanks

 

[Paul B]

In sheet 2 put =Sheet1!A1+7 and in sheet 3 put =Sheet1!A1+14 or =Sheet2!A1+7
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

I need to know how to format worksheets in a workbook and have them

reconize "3-d" cell references.

i.e. cell a1 on sheet 1 is todays date, need to have cell a1 on sheet 2

read the date 7 days later, sheet 3 another 7 days etc.

 

[RagDyer]

Here's a thread that shows two different approaches:

http://tinyurl.com/ywpb8
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I need to know how to format worksheets in a workbook and have them reconize
"3-d" cell references.
i.e. cell a1 on sheet 1 is todays date, need to have cell a1 on sheet 2 read
the date 7 days later, sheet 3 another 7 days etc.

All attempts to do this on the additional sheets keeps referencing sheet 1.

Thanks