Advertisements

Excel – Calculate the number of days in a month

Use below formula to extract the number of days for a specific month

=DAY(DATE(theyear,themonth+1,1)-1)

For Example; suppose you require to display number of days for the month of Feb 2014

=DAY(DATE(2014,2+1,1)-1)

This equals 28

Advertisements

About Sunil Padmanabhan

An Indian based out of Dubai who started traveling from 2011 and pretty much caught the travel bug. Every year presents itself as an opportunity to visit and explore a new place.

Posted on January 24, 2015, in Excel, MS Office. Bookmark the permalink. Leave a comment.

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

%d bloggers like this: