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.