Posted to microsoft.public.excel.misc
|
|
Custom fill series?
Wow - that is just what I wanted!
Thank you so much.
Martin
"Don Guillett" wrote:
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
|