Calendar - Ajit
 

I have entered the month as February, 2005 in cell A1. Now I
want excel to show the days from b1 to b28 as Tue, Wed etc.
till b28 (as there are 28 days in Feb 2005). Excel should
calculate the no. of days in the month & year entered in
cell A1

Ajit
--
Knowldege is Power

Hi

Into A1, enter the month as 1st of February, 2005, and format the cell as
Custom "mmm, yyyy"
B1=IF(MONTH($A$1+ROW()-1)=MONTH(A1),$A$1+ROW()-1,"")
Copy down for 31 rows, and format as Custom "ddd"

The number of days in month:
=DAY(DATE(YEAR($A$1),MONTH($A$1)+1,0))

The number of days in year:
=DATEDIF(DATE(YEAR($A$1),1,1),DATE(YEAR($A$1),12,3 1),"D")+1

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Ajit Munj" wrote in message
...
I have entered the month as February, 2005 in cell A1. Now I
want excel to show the days from b1 to b28 as Tue, Wed etc.
till b28 (as there are 28 days in Feb 2005). Excel should
calculate the no. of days in the month & year entered in
cell A1

Ajit
--
Knowldege is Power

Hi

Another formula to calculate the number of days in year:
=365+(MONTH(DATE(YEAR($A$1),2,29))=2)


--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets