Automate a date referenced in a formula pointing to another sheet

B

Birt36

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.
 
M

Mladen_Dj

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

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

Mladen_Dj

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).
 
B

Birt36

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?
 
M

Mladen_Dj

maybe it's sintax??

The bigining "'" in =INDIRECT("'" is quotes-apostrophe-quotes, and "' is
quotes-apostophe in "'!$V$35

I'm tested formula few times and it works 100%.
 
B

Birt36

Thank You for the help.

I am mailing you the exact formula in my cell. Please tell me somethings
wrong with it.....

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

Thank You Again.
 
M

Mladen_Dj

I was copy it, and it works for me... well i realy can't explain than... if
you have datevalue for 11 November 2005 in cell A1, and other worksheet
named 11-11-05 it should work because here works without any problems...
Strange... I wish I can help you more
 
B

Birt36

I don't understand it either. Is it possible for you to email, or attach a
copy of your working spreadsheet?
 
M

Mladen_Dj

Just send me e-mail to mister.guroREMOVE[at]gmail.com and I will send you my
workbook...
 
Top