You can enter a Sunday date, and the right click and drag down as needed.
When the mouse is released, the bottom choice in the option window is
'Series'.
Click on that, and enter 7 in the 'StepValue' box, then <OK.
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"martinkorner" wrote in message
...
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