Number of Days in a Month – Formulas in Excel and Google Sheets

This tutorial will teach you how to calculate the number of days in a month using Excel or Google Sheets.

Days in month Main

Calculate Number of Days in a Month

Last Day of Month

The first step to calculating the number of days in a month is to calculate the last day of the month. We can easily do this with the EOMONTH Function:

Last Day on the Month

We enter the date into the EOMONTH Function and “0” to calculate the last day of the current month (we would use -1 to calculate the last day of the previous month).

Calculate Day

Next we use the DAY Function to extract the day number of the last day of the month:

Calculate Day

This will tell us the number of days in the month.

Number of Days in Current Month

We can utilize the TODAY Function to calculate the last day of the current month:

No Of Days Current Month

Number of Days in Previous Month

As mentioned above we can set the second argument of the EOMONTH Function to -1 to calculate the last day of the previous month:

NO of Days in Previous Month

Days in Month – Google Sheets

There formulas work exactly the same in Google Sheets as in Excel:

Days in month Google sheet

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!