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?
--
Knowldege is Power

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

regards
FSt1

"Ajit Munj" wrote:

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?
--
Knowldege is Power

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


"FSt1" wrote:

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

regards
FSt1

"Ajit Munj" wrote:

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?
--
Knowldege is Power