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

--
Biff
Microsoft Excel MVP


"Mr. Low" wrote in message
...
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