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.
This works by using a date in cell A1. So if you wanted the number of days in the current month simply use
A very handy tip that you might need when calculating monthly averages.