Days of a given month
Can anybody help me?
I need to get the number of days on a given month-year. (ie Jan-07 = 31
days, etc)
Is there an easy way to get it?
=DAY(DATE(YearNumber,MonthNumber+1,0))
Put the year number in the first argument, the month number PLUS one in the
second argument and zero in the third argument.
Rick
|