Excel 2002: How to get the number of days in the month ?

  • Thread starter Thread starter Mr. Low
  • Start date Start date
M

Mr. Low

Hi,

I have a long list of dates.

May I know if there is a formula for me to get the number of days in for
that month in that year ?


A B
Total days
Date in the month
5 06/05/2011 31
6 13/02/2011 28
7 24/08/2011 31
8 7/12/2011 31
200 09/04/2011 30


Thanks

Low
 
Try one of these...

=DAY(EOMONTH(A5,0))

That requires that the Analysis ToolPak add-in be installed in Excel
versions 2003 and earlier.

=32-DAY(A5-DAY(A5)+32)

=DAY(DATE(YEAR(A5),MONTH(A5)+1,0))
 
One way

=DATE(YEAR(A3),MONTH(A3)+1,0)-DATE(YEAR(A3),MONTH(A3),0)
and format the formula cell to General..

If this post helps click Yes
 
Back
Top