Calendar - Ajit

[Guest]

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

 

[Arvi Laanemets]

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,31),"D")+1

 

[Arvi Laanemets]

Hi

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