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

[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

 

[Jim Thomlinson]

Try this where your date ios in cell A1

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

 

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

 

[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

 

[Jacob Skaria]

You mean

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

If this post helps click Yes

 

[NBVC]

Try:

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

formatted as genera

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[Jim Thomlinson]

You are correct...
--
HTH...

Jim Thomlinson

You mean

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

If this post helps click Yes

 

[gwen]

What about
=DAY(EOMONTH(A5,0))

gwen

You mean

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

If this post helps click Yes

 

[Mr. Low]

Hi Valko,

i try =32-DAY(A5-DAY(A5)+32) and it works.

Thanks for your help.

Low

 

[T. Valko]

You're welcome. Thanks for the feedback!