Calculate Number of Days in a Month

Microsoft excel can find last day of month using following method
.
.
Put any date in cell A1
.
A1 => 01-Jan-2012
.
and use following formulae to find number of days in a month
.
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
.
.
Output will be 31