How to get the number of days in a month with an Excel formula

This tip shows you how to use Excel formulas to work out the number of days in a given month

It’s October 17th as I write this quick tip. So how would we use an Excel formula to work out the number of days in the current month? Simply use the formula below.

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

This works by using a date in cell A1. So if you wanted the number of days in the current month simply use

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

A very handy tip that you might need when calculating monthly averages.

Related posts:

1. Group pivot table data by date, month or year with just a few clicks
2. Use the DATEDIF function in Excel to calculate the time period between two dates
3. How to do a countif using a date expression
4. Create Tableau charts in Excel
5. Excel 2013 New Features – Timeline Filters