How Many Days Left in Month / Year – Excel & Google Sheets

This tutorial will demonstrate how to find the total number of days Remaining in a Month or a Year.

days left month year Main Function

Remaining Days in Month using EOMONTH Function

The EOMONTH Function returns the last day of a month. Its syntax is:

EOMONTH Function

We can simply subtract the start date from the last day of the month to find the number of days Remaining:

Days left in a Month

Remaining Days in Month using TODAY Function

In this example, we’ll see how to find the remaining number of days in a month starting today.

Days left in a Month (TODAY)

The nested TODAY Function returns input for the ‘start_date’ argument of the EOMONTH Function.

Remaining Days in Year using DATE Function

To calculate the days remaining in a year, we will use the DATE Function. Its syntax is:

Date Function

Here we will subtract the start date from the last day of the year:

Days left in a Year

Days Remaining in Year using TODAY Function

The following example calculates the remaining number of days in a year starting with today.

Days left in a Year (TODAY)

Days Remaining Month/Year in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.

days left month year Google Function

 

Excel Practice Worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!