Hi Matt,

Just a slight alteration to your formula that will also eliminate the
need for A2. (It may show below as wrapped to several lines.
Obviously, you'd enter it all on 1 line.)


=DAY(A1)&IF(OR(AND(MOD(DAY(A1),100)=4,MOD(DAY(A1) ,100)
<=20),AND(MOD(DAY(A1),100)=24,MOD(DAY(A1),100)<=3 0)),"th",
CHOOSE(MOD(DAY(A1),10),"st","nd","rd","th","th","t h","th","th","th"))&"
"&TEXT(A1,"mmmm yyyy")


Paul