Custom fill series?
Right then...I've got a solution!!
I also realised the problem with 21, 22, 23 and 31.
So I made this formula...It's probably far longer than it needed to be, but
this works, so I'm happy with it:
---------------------------------
=DAY(A60)&LOOKUP(DAY(A60),{1,2,3,4,5,6,7,8,9,10,11 ,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,2 8,29,30,31},{"st","nd","rd","th","th","th","th","t h","th","th","th","th","th","th","th","th","th","t h","th","th","st","nd","rd","th","th","th","th","t h","th","th","st"})&TEXT(A60," mmmm")&TEXT(A60," yyyy")
---------------------------------
It basically specifies the suffix for each individual date.
Martin
"David" wrote:
For me, all offerings failed to provide proper ordinal for days 21, 22, 23,
31
--
David
?B?bWFydGlua29ybmVy?= wrote
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
|