Calendar

[Ajit Munj]

I want Excel to show days like Sun,Mon,Wed in Row2 and below that dates like
1,2,3 if I put a particular month and year in cell a1 e.g. if in cell a1 i
put Oct 2007, Excel should show Mon, Tue, Wed in row2 and below that 1 upto
month end in row3. At the same time, Excel should colour all values in RED
below Colum Sunday. How can I ahieve this?

 

[FSt1]

hi
http://www.rondebruin.nl/calendar.htm
see if this will work for you.

regards
FSt1

 

[Ajit Munj]

sorry, it didn't help me. I want excel to fill the days and dates
automatically
when I change the month in cell a1