View Single Post
  #4   Report Post  
Dave O
 
Posts: n/a
Default

It's a little chunky, but this works:
=(IF(MOD((DAY(A1)),10)=1,DAY(A1)&"st",IF(MOD((DAY( A1)),10)=2,DAY(A1)&"nd",IF(MOD((DAY(A1)),10)=3,DAY (A1)&"rd",DAY(A1)&"th"))))&TEXT(A1,"
mmmm ")&YEAR(A1)

.... where your date is in A1.