| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automate a date referenced in a formula pointing to another sheet
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. |
|
#2
|
|||
|
|||
|
Automate a date referenced in a formula pointing to another sheet
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. |
|
#3
|
|||
|
|||
|
Automate a date referenced in a formula pointing to another sh
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. |
|
#4
|
|||
|
|||
|
Automate a date referenced in a formula pointing to another sh
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. |
|
#5
|
|||
|
|||
|
Automate a date referenced in a formula pointing to another sh
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. |
|
#6
|
|||
|
|||
|
Automate a date referenced in a formula pointing to another sh
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. |
|
#7
|
|||
|
|||
|
Automate a date referenced in a formula pointing to another sh
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. "Mladen_Dj" wrote: 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. |
|
#8
|
|||
|
|||
|
Automate a date referenced in a formula pointing to another sh
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 "Birt36" wrote in message ... 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. "Mladen_Dj" wrote: 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. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automate a date referenced in a formula pointing to another sh
I don't understand it either. Is it possible for you to email, or attach a
copy of your working spreadsheet? "Mladen_Dj" wrote: 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 "Birt36" wrote in message ... 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. "Mladen_Dj" wrote: 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. |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automate a date referenced in a formula pointing to another sh
Just send me e-mail to mister.guroREMOVE[at]gmail.com and I will send you my
workbook... "Birt36" wrote in message ... I don't understand it either. Is it possible for you to email, or attach a copy of your working spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Value between 2 dates | Excel Worksheet Functions | |||
| copy formula referencing sheet name to another sheet | Excel Worksheet Functions | |||
| Date Formula | Excel Discussion (Misc queries) | |||
| How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Linear Mode
