Number of days in a month

[Don C]

The function WEEKDAY will tell me the day of the week that a date falls on.

How can I determine the number of days in the month of that date?

In cell A2, I enter a date, say 1/1/2003 and I want to know the number of days in January.

(I know, I can look on a calendar, but I'd like some sort of automation. Next year is a Leap Year and I'd like the calendar I am building to know that.)

Thanks

 

[olivierv]

Thanks, very helpful.

 

[barry houdini]

For any date in A2 you can find the number of days in that month with this formula

=42-DAY(A2-DAY(A2)+42)

 

[HamadaGam]

Dear

insert table as following :

Column B (B1) Month, (B2) Jan-2015 , (B3) Feb-2015 , (B4) Mar-2015 ..... till Dec-2015
Column C (C1) Month No., (C2) =MONTH(B2), (C3)=MONTH(B3), (C4)=MONTH(B4)....till =MONTH(B13)
Column D (D1)Days, (C2) =DAY(EOMONTH(B2,0)), (C3)=DAY(EOMONTH(B3,0)), (C4)=DAY(EOMONTH(B2,0))....till =DAY(EOMONTH(B13,0))

then follow the following Equation assumed that date is 24 Aug 2015 in Cell G2 :

=VLOOKUP((MONTH(G2)),$C$1:$D$13,2,0)

 

[ashokpai]

The function WEEKDAY will tell me the day of the week that a date falls on.

How can I determine the number of days in the month of that date?

In cell A2, I enter a date, say 1/1/2003 and I want to know the number of days in January.

(I know, I can look on a calendar, but I'd like some sort of automation. Next year is a Leap Year and I'd like the calendar I am building to know that.)

Thanks

Hi,

Try the following formula

=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)

 

[asad]

I know this is an old thread. But still, here is something very short and simple:

=day(eomonth(A1,0))