You mean

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

If this post helps click Yes
---------------
Jacob Skaria


"Jim Thomlinson" wrote:

Try this where your date ios in cell A1

=DAY(DATE(YEAR(A1), MONTH(A1), 0))
--
HTH...

Jim Thomlinson


"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