Ignore mine... the first 0 should have been YEAR(A1) as the others have
posted.

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
Here is one way to get the value...

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

Rick


"Sena" wrote in message
...
Hi there,

Am looking a formulae that would return the number of days for a given
month.

eg :
A1 = 1/1/07 ( meaning Jan )
A2 = need the number of days in Jan (result - 31)

B1 = 1/11/07 ( meaning Nov )
B2 = need the number of days in Nov (result -30)

Thanks
--
Cheers !