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.