Concatenate

[LWilson]

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$20,IF(VLOOKUP(RIGHT(T$19,3),$I$25:$J$41,2,FALSE)=MONTH($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.

 

[LWilson]

Let me add that the date format, when complete would be 2009.Dec.09

 

[Teethless mama]

My problem is that for days that have single digits, I need it to be 01,
02, etc

=TEXT(DAY($K$44),"00")

 

[LWilson]

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!

 

[Jacob Skaria]

What "Teethless mama" has suggested is to replace

DAY($K$44)

with

TEXT(DAY($K$44),"00")

 

[LWilson]

Thank you! I figured that out later!

What "Teethless mama" has suggested is to replace

DAY($K$44)

with

TEXT(DAY($K$44),"00")