Calendar

A

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?
 
A

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
 
Top