Remaining days to New Year from a specific date

This tutorial shows how to calculate the remaining days from a specific date to New Year in Excel

Excel

Remaining days to New Year from a specific date including end date

Excel

Remaining days to New Year from a specific date excluding end date

EXCEL FORMULA 1. Remaining days to New Year from a specific date including end date

EXCEL

Remaining days to New Year from a specific date

=DATE(YEAR(B5),12,31)+1-B5

GENERIC FORMULA

=DATE(YEAR(date),12,31)+1-date

ARGUMENTS
date: The date from which you want to calculate the remaining days to new year.

EXPLANATION

This formula uses a combination of the DATE and YEAR function to calculate the number of days left in a year from a specific date, including the end date. At the beginning of the formula we use the DATE function to return the last date for the selected date's year, with the month and day fixed at 12 months (representing the December month number) and 31 days (representing the last day in December). The year of the selected date is derived with the use of the YEAR function.

We add a value of one (1) to the DATE function to include the end date and then subtract the specific date. This will return the number of days remaining until the new year from the selected date, including the end date.

EXCEL FORMULA 2. Remaining days to New Year from a specific date excluding end date

EXCEL

Remaining days to New Year from a specific date

=DATE(YEAR(B5),12,31)-B5

GENERIC FORMULA

=DATE(YEAR(date),12,31)-date

ARGUMENTS
date: The date from which you want to calculate the remaining days to new year.

EXPLANATION

This formula uses a combination of the DATE and YEAR function to calculate the number of days left in a year from a specific date, excluding the end date. At the beginning of the formula we use the DATE function to return the last date for the selected date's year, with the month and day fixed at 12 months (representing the December month number) and 31 days (representing the last day in December). The year of the selected date is derived with the use of the YEAR function.

The formula then subtracts the specified date. This will return the number of days remaining until the new year from the specified date, excluding the end date.

Related Functions	Description	Related Functions and Description
DATE Function	The Excel DATE function returns a date through the use of individual year, month and day parameters
YEAR Function	The Excel YEAR function returns the year from a specified date