Calculating Number of days in a month – MS Excel

How to calculate No of days in a given month?

=DAY(DATE(YEAR(A2),MONTH(A2)+1,1)-1)

Where “A2” contains date . i.e 11-Aug-2014

 

Update:  In excel 2007 onwards you can use EOMONTH(start-date , no-of-months) function.

Advertisements