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

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
 
J

Jim Thomlinson

Try this where your date ios in cell A1

=DAY(DATE(YEAR(A1), MONTH(A1), 0))
 
T

T. Valko

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))
 
J

Jacob Skaria

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
 
J

Jacob Skaria

You mean

=DAY(DATE(YEAR(A3), MONTH(A3)+1, 0))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find then highlight in yellow 6
Count specific days in between dates 2
Calculating occupational sick pay entitlement 0
Formula Help: Monthly Statistics 2
calculate number of days 7
days of the current month 2
Count the Number of Weekdays by Month 3
Excel Stuck trying to use Excel 2007 Countifs. 1

Top