Days in a month
On Fri, 9 Oct 2009 07:49:01 -0700, helpforwork
wrote:
Is there a formula that can populate how many days there are in a month? i.e.
31 days in January, 28 days in February, and so on
With some date in A1:
=DAY(A1-DAY(A1)+32-DAY(A1-DAY(A1)+32))
Format result as General, or Number
--ron
|