Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar based on varying information/ Pivot Table General | Charts and Charting in Excel | |||
Pop-up calendar shows up as a red X | Excel Discussion (Misc queries) | |||
Calendar and info for that date | Excel Discussion (Misc queries) | |||
Calendar 13 Periods 4 weeks each | Excel Discussion (Misc queries) | |||
Weekly data into Calendar Weeks | Excel Worksheet Functions |