Thread
:
Add st and th to dates
View Single Post
#
4
Dave O
Posts: n/a
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.
Reply With Quote