Combine text and date together in special format.

[sunnyp]

A B c D

4/5(date) 4/6 (Date) =B2-A2 I wanted to get in D2= State Tax:-[4/5] through formula when i put d2= If(C2>1,"State Tax:-"&TEXT(A2,"mm/dd"),"") i get State Tax:-4/5 but i wanted to get State Tax:[4/5] how do i do this cell A2 and B2 are in date format.

 

[SirJB7]

Hi, sunnyp!

Maybe being out of business for a while makes me a bit dull to understand, but maybe you could elaborate and post an example or upload a sample file? I didn't get your point.

Regards!

PS: and as a matter of fact I didn't find any "point" in your post, exception made of the last one

 

[NARAYANK991]

Hi ,


Try this :


=IF(C2>1,"State Tax:["&TEXT(A2,"m/d)&]","")


Narayan

 

[SirJB7]

@NARAYANK991

Hi!

Thanks for intervening, surely it maybe what sunnyp was asking for and I didn't understand.

BTW, nice to read you again.

Regards!

 

[NARAYANK991]

Hi Pablo ,


Thanks , and wishing you a full recovery.


Narayan

 

[Hui]

also see: http://chandoo.org/forums/topic/date-format-in-mmdd-format

 

[sunnyp]

Thanks Narayank991 for your help.