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.

Leave a Reply

  

  

  


5 + one =

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>