On Thu, 7 Apr 2005 10:17:04 -0700, "Ryan Proudfit"
wrote:

I need a function or formula that will return the number of days in a month.
I saw it in one of my reference books, but I'll probably never find it again.
Please help.


Given any date in a month in A1, the number of days in that month is:

=32-DAY(A1-DAY(A1)+32)


--ron