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


"Mr. Low" wrote:

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

--
A36B58K641