Thank you for your help,

It is formated as a date. November 11, 2005.. When I use the Evaluate
button, it shows the correct figure (in Parinithies) but the cell shows REF
Error. It is changing the date to Julian, then back to the format defined,
but then an error.

Any Thoughts?


"Mladen_Dj" wrote:

hmm, everything is ok at me. Are your target worksheet have name in mm-dd-yy
format for sure and does date in A1 is value (number) or text ?? It should
be value, othervise you must convert it to value...VALUE(A1).

"Birt36" wrote in message
...
Thank You.

But it did not work. I get a REF Error in the cell.

"Mladen_Dj" wrote:

try with formula (suppose date is in cell A1):

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$35")


"Birt36" wrote in message
...
I am trying to reference a date in a formula that points to a sheet
name.
See Below.

A B
November 11, 2005 ='11-11-05'!$v$35

How can I automate the date to pull from column A and place that value
in
the date for column B? Column B is the name of a different sheet in
the
workbook.