Leave Cell blank if formula empty

[Desu Nota from Columbus]

I have this formula (see below) set in columns F and G to convert DateTime (columns B & C) to Month/Day/Year. I applied this formula to the entire column so when columns B & C are empty, the date is still converted to 1/0/1900 all the way to cell 65000+


=MONTH(B3) & "/" & DAY(B3) & "/" & YEAR(B3)


Is there a way to force this to say, If no value in B and C, then leave blank in F and G?

 

[VoG]

Try
=IF(B3="","",MONTH(B3) & "/" & DAY(B3) & "/" & YEAR(B3))

 

[JackDanIce]

Try:

=IF(OR(ISEMPTY(B3),B3=""),"",MONTH(B3) & "/" & DAY(B3) & "/" & YEAR(B3))

 

[Desu Nota from Columbus]

Thank you for your help!

it is now working

 

[Jonmo1]

Try

=TEXT(B3,IF(ISNUMBER(B3),"mm/dd/yyyy",""))