Return to Excel Formulas List

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

Download Example Workbook

Download the example workbook

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

days left month year

 

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

This example will calculate the number of days remaining from today.

Days left in a Month (TODAY)

The nested TODAY Function returns input for the start_date input for 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

The YEAR Function returns the current year. The Date Function outputs the last day of the year.

By subtracting the values we calculate the number of days left in the 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