Hello Malcolm:

I don’t know if this will work with Excel 2000 but try this.

The date goes in cell A1 and the day ( =DAY(A1) ) goes in cell A2.

=A1&IF(AND(MOD(A1,100)=10,MOD(A1,100)<=14),"th",C HOOSE(MOD(A1,10)+1,"th","st","nd","rd","th","th"," th","th","th","th"))&"
"&TEXT(A2,"mmmm yyyy")

I got this from this web site listed under excel tips.

I hope this helps.

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=383056