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 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