referencing another page

[johngio]

Hi,

I have 2 worksheets. The first is named 1. The second is named 2. In page 1 I have:

A1 - 2/03/2004
B2 - =('DAY(A1)'!C3)

On sheet 2, in cell C3 I have the text - woohoo!!!!

What I want to do is get this text to appear in cell B2 (page 1), by making it find the worksheet name via the date (as I want to have 31 worksheets, each corresponding to a different date).

My formula in B2 is giving me a referencing error. . . .

Any ideas why ? ?

 

[Scott Huish]

Change your B2 formula to this:

=INDIRECT(DAY(A1)&"!C3")

 

[johngio]

thanks

Worked a treat!!!