Wendy,

For a date in A1:

=TEXT(A1,"mmmm ") &
IF(DAY(A1)0,DAY(A1)&IF(AND(DAY(A1)10,DAY(A1)<20) ,"th",CHOOSE(MOD(DAY(A1),10)+1,"th","st","nd","rd" ,"th","th","th","th","th","th")),"")

HTH,
Bernie
MS Excel MVP


"Wendy D" wrote in message
...
Wondering if excel can express mmm dd dates including their ordinal?
Examples a May 4th, October 1st, June 3rd.

Thanks!
Wendy