Assuming that A1 contains a date, such as 2/15/06, try...

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

Hope this helps!

In article ,
"FGOMEZ" wrote:

I am just wondering if there is a function that gives you the number days of
the month for a given date.

Thanks