how do i format date with text in a formula?

[Dark0Prince]

Below is my formula and I need to format the date to the text I've added. I've tried using OFFSET((PIF_REPORT!$J$4,1,0,1,1),"mm-dd-yyyy") nothing seems to work. The date still loooks like 43060

=IF(ISNUMBER(SEARCH("15250E",(OFFSET(PIF_REPORT!B4,1,0,1,1)))),"test3 Manager",IF(ISNUMBER(SEARCH("15251E",(OFFSET(PIF_REPORT!B4,1,0,1,1)))),"test2 Manager",IF(ISNUMBER(SEARCH("15252E",(OFFSET(PIF_REPORT!B4,1,0,1,1)))),"test1 Manager",OFFSET(PIF_REPORT!$J$4,1,0,1,1) &" is the date i'm looking for")))

 

[63falcondude]

Try

TEXT(OFFSET((PIF_REPORT!$J$4,1,0,1,1),"mm-dd-yyyy")&" is the date i'm looking for"

 

[macattackpro]

Try using the TEXT formula:

=TEXT('your formula here'<your here="" formula="">,"mm/dd/yyyy")

Just put in your formula that brings in the 43060 and make sure the quotes are around "mm/dd/yyyy". If you want it in "mm-dd-yyyy" then use hyphens instead of forward slash.</your>

 

[Joe4]

You want to use TEXT, i.e.
TEXT(value you want to format,"mm-dd-yyyy")