How Many Days Left in Month / Year – Excel & Google Sheets
Written by
Reviewed by
Download the example workbook
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:
=EOMONTH(B3,0)-B3
Remaining Days in Month using TODAY Function
This example will calculate the number of days remaining from today.
=EOMONTH(TODAY(),0)-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:
Here we will subtract the start date from the last day of the year:
=DATE(YEAR(B3),12,31)-B3
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.
=DATE(YEAR(TODAY()),12,31)-TODAY()
Days Remaining Month/Year in Google Sheets
These formulas work exactly the same in Google Sheets as in Excel.
