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.
|