# 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. ## Remaining Days in Month using EOMONTH Function

The EOMONTH Function returns the last day of a month. Its syntax is: We can simply subtract the start date from the last day of the month to find the number of days Remaining: ## 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. 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: Here we will subtract the start date from the last day of 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 Remaining Month/Year in Google Sheets

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