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.

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.

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.

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.

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.

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


"Birt36" wrote in message
...
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.