Excel Fox
05-14-2011, 08:00 PM
To find the number of days in a month, one can use the formula
=DAY(DATE(1,A1+1,0)) where A1 is the number of the month, for example January = 1, February = 2
=DAY(DATE(1,A1+1,0)) where A1 is the number of the month, for example January = 1, February = 2