Try:

=IF(B5="","",TEXT($B5,"mmm"))
--
Gary''s Student


"GregR" wrote:

What is wrong with this formula?

=IF(TEXT($B5,"mmm")"",TEXT($B5,"mmm"),"")

If B5 contains a date the answer is right, but if B5 is blank it still
returns a value. The expected result is if B5 is blank then C5 is
blank. TIA

Greg