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

Author: Abdul Salam

I am just a learner

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s