On Sat, 5 Jan 2008 22:27:00 -0800, Sena wrote:

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

If you have the Analysis Tool Pak installed, or are using Excel 2007, you can
try:

=DAY(EOMONTH(A1,0))


--ron