Peter,

Put this formula in A2 and copy down to A31

=IF(A1<"",IF(MONTH(A1+1)=MONTH($A$1),A1+1,""),"")

and format as "ddd d", doesn't show the ordinal value I am afraid.

If you only want working days, add conditional formatting and a formula of
=WEEKDAY(A1,2)5
and give a font colour of white

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Peter" wrote in message
...
Ideally I'd like to create a calandar like this:
1. Put "01/02/04" in a cell A1 and in cells B1 to B35 I get returned each
day in Feb listed eg: Mon 1st Feb, Tue 2nd Feb etc.
2. I don't want to run into March so I can't use 1/2/04 +1, +1....+31
because I'll get 3rd March in the Feb calculation, but 31st Oct in the Oct
calculation!
3. Can I do the above but only show working days (Mon-Fri).
4. Finally. Can I draw a line at the start of every Monday.

Any help to any of the above gratefully recieved
Many thanks
--
Peter
London, UK