Hi Terry,

Am Sat, 17 Feb 2018 22:46:32 +0000 schrieb Terry Pinnell:

=TEXT(B6,"dddd")&"
"&DAY(B6)&IF(OR(DAY(B6)={1,2,3,21,22,23,31}),CHOOS E(1*RIGHT(DAY(B6),1),"st
","nd ","rd "),"th ")&TEXT(B6,"mmmm yyyy")

try:
=TEXT(B6,"dddd ")&DAY(B6)&IFERROR(VLOOKUP(DAY(B6),{1,"st";2,"nd"; 3,"rd";21,"st";22,"nd";23,"rd";31,"st"},2,0),"th") &TEXT(B6," MMMM YYYY")


Regards
Claus B.
--
Windows10
Office 2016