Chip Pearson has some notes (plus formulae and macro) on ordinal numbers
he

http://www.cpearson.com/excel/ordinal.htm

Perhaps you can incorporate the ideas in your sheet.

Hope this helps.

Pete

"ProudFoot" wrote in message
...
thanks, I wasn't clearin my post.

The date will change to any day of the month so what can I do about the
1st,
2nd, 3rd, 21st, 22nd, 23rd, etc...


"FSt1" wrote:

hi
not a formula but 3 formulas with concatinators.
date in b2?......

=DAY(B2)&"th Day of "&TEXT(B2,"mmmm")&", "&YEAR(B2)

regards
FSt1

"ProudFoot" wrote:

Is there a formula or VBA code to make "July 8, 2008" automatically say
"8th
day of July, 2008"?


Any help is appreciated.