Nel post
*martinkorner* ha scritto:

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


Hi Martin,

I suppose you have the real dates in column A, starting from A1 (in A2 type
=A1+7 and copy down). In B1 copy this formula:

=DAY(A1)&IF(DAY(A1)=1,"st",IF(DAY(A1)=2,"nd",IF(DA Y(A1)=3,"rd","th")))&"
"&UPPER(TEXT(A1,"mmmm"))&" "&TEXT(A1,"yyyy")

and fill down.

IMHO there is no simple way to have st, nd, rd and th as superscript, maybe
with a macro, but I can't support you that way.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy