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.

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.

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.

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.

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.

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.