How do I Ref a cell with dates as a worksheet

[dereidar]

I was hoping someone could help me with this...

I am trying to reference a cell that has a date similar to the worksheet to save time typing and linking.

I have dates in Column A that are formated as 03-31-2011 and the work sheets are named 03-31-2011

My formula is =INDIRECT(A1&"!E12") it works for numbers, but not dates. I get REF! error.

Any ideas what I'm doing wrong?

 

[BobUmlas]

If there's a date in A1, it's value is still a serial #, like 40293, not a date -- you need the formatted value, like
=INDIRECT(TEXT(A1,"mm-dd-yyyy")&"!E12")

 

[dereidar]

I'm still getting the REF error even though the calculation steps look correct. The worksheet name is also a date thats formated mm-dd-yyyy

Does that pose a problem?

 

[BobUmlas]

Try this:
=INDIRECT("'" & TEXT(A1,"mm-dd-yyyy")&"'!E12")

(surrounding the sheet name with a single quote)

 

[dereidar]

Worked like a charm Bob! Thank you!