Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate
I'm using the Concatenate function to return a date. My problem is that for
days that have single digits, I need it to be 01, 02, etc. How can I make this work. Here is my formula: IF(LEFT(T$19,2)="FY",S$20,IF(LEFT(T$19,2)="CY",S$2 0,IF(VLOOKUP(RIGHT(T$19,3),$I$25:$J$41,2,FALSE)=MO NTH($K$44),CONCATENATE(T$19,".",DAY($K$44)),EVTIM( $D$79,CONCATENATE(EVTIM($C$17,T$19,1),".","01"),-1)))) Thank you for any help you can provide. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate
Let me add that the date format, when complete would be 2009.Dec.09
"LWilson" wrote: I'm using the Concatenate function to return a date. My problem is that for days that have single digits, I need it to be 01, 02, etc. How can I make this work. Here is my formula: IF(LEFT(T$19,2)="FY",S$20,IF(LEFT(T$19,2)="CY",S$2 0,IF(VLOOKUP(RIGHT(T$19,3),$I$25:$J$41,2,FALSE)=MO NTH($K$44),CONCATENATE(T$19,".",DAY($K$44)),EVTIM( $D$79,CONCATENATE(EVTIM($C$17,T$19,1),".","01"),-1)))) Thank you for any help you can provide. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate
My problem is that for days that have single digits, I need it to be 01,
02, etc =TEXT(DAY($K$44),"00") "LWilson" wrote: I'm using the Concatenate function to return a date. My problem is that for days that have single digits, I need it to be 01, 02, etc. How can I make this work. Here is my formula: IF(LEFT(T$19,2)="FY",S$20,IF(LEFT(T$19,2)="CY",S$2 0,IF(VLOOKUP(RIGHT(T$19,3),$I$25:$J$41,2,FALSE)=MO NTH($K$44),CONCATENATE(T$19,".",DAY($K$44)),EVTIM( $D$79,CONCATENATE(EVTIM($C$17,T$19,1),".","01"),-1)))) Thank you for any help you can provide. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate
I believe this will work, but I'm having trouble determining where in my
formula it should go? I feel like an idiot. LOL! Thanks in advance for your help! "Teethless mama" wrote: My problem is that for days that have single digits, I need it to be 01, 02, etc =TEXT(DAY($K$44),"00") "LWilson" wrote: I'm using the Concatenate function to return a date. My problem is that for days that have single digits, I need it to be 01, 02, etc. How can I make this work. Here is my formula: IF(LEFT(T$19,2)="FY",S$20,IF(LEFT(T$19,2)="CY",S$2 0,IF(VLOOKUP(RIGHT(T$19,3),$I$25:$J$41,2,FALSE)=MO NTH($K$44),CONCATENATE(T$19,".",DAY($K$44)),EVTIM( $D$79,CONCATENATE(EVTIM($C$17,T$19,1),".","01"),-1)))) Thank you for any help you can provide. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate
What "Teethless mama" has suggested is to replace
DAY($K$44) with TEXT(DAY($K$44),"00") -- Jacob "LWilson" wrote: I believe this will work, but I'm having trouble determining where in my formula it should go? I feel like an idiot. LOL! Thanks in advance for your help! "Teethless mama" wrote: My problem is that for days that have single digits, I need it to be 01, 02, etc =TEXT(DAY($K$44),"00") "LWilson" wrote: I'm using the Concatenate function to return a date. My problem is that for days that have single digits, I need it to be 01, 02, etc. How can I make this work. Here is my formula: IF(LEFT(T$19,2)="FY",S$20,IF(LEFT(T$19,2)="CY",S$2 0,IF(VLOOKUP(RIGHT(T$19,3),$I$25:$J$41,2,FALSE)=MO NTH($K$44),CONCATENATE(T$19,".",DAY($K$44)),EVTIM( $D$79,CONCATENATE(EVTIM($C$17,T$19,1),".","01"),-1)))) Thank you for any help you can provide. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate
Thank you! I figured that out later!
"Jacob Skaria" wrote: What "Teethless mama" has suggested is to replace DAY($K$44) with TEXT(DAY($K$44),"00") -- Jacob "LWilson" wrote: I believe this will work, but I'm having trouble determining where in my formula it should go? I feel like an idiot. LOL! Thanks in advance for your help! "Teethless mama" wrote: My problem is that for days that have single digits, I need it to be 01, 02, etc =TEXT(DAY($K$44),"00") "LWilson" wrote: I'm using the Concatenate function to return a date. My problem is that for days that have single digits, I need it to be 01, 02, etc. How can I make this work. Here is my formula: IF(LEFT(T$19,2)="FY",S$20,IF(LEFT(T$19,2)="CY",S$2 0,IF(VLOOKUP(RIGHT(T$19,3),$I$25:$J$41,2,FALSE)=MO NTH($K$44),CONCATENATE(T$19,".",DAY($K$44)),EVTIM( $D$79,CONCATENATE(EVTIM($C$17,T$19,1),".","01"),-1)))) Thank you for any help you can provide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONCATENATE | Excel Discussion (Misc queries) | |||
Concatenate | Excel Discussion (Misc queries) | |||
Need to Concatenate | Excel Discussion (Misc queries) | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Un-concatenate | Excel Discussion (Misc queries) |