Here is a formula for an adjacent column. You could use a macro to ask for a
date and fill in


=DAY(D7)&LOOKUP(DAY(D7),{1,2,3,4},{"st","nd","rd", "th"})&TEXT(D7," mmm")

--
Don Guillett
SalesAid Software

"martinkorner" wrote in message
...
I need to have a collumn in my spreadsheet which will display every
Sunday's
date.

e.g.
25TH JUNE 2006
1ST JULY 2006
8TH JULY 2006
etc...

I also need the "TH" "ST" ND" and "RD" 's to be in superscript.

I am using Excel 2002 (XP) on a Windows XP Home Edition PC.

Thanks,
Martin