Return last day of a current year

This tutorial shows how to calculate the last day of a current year using an Excel formula, with the DATE, YEAR and TODAY functions

EXCEL FORMULA 1. Return last day of a current year

EXCEL

Return last day of a current year

=DATE(YEAR(TODAY()),12,31)
GENERIC FORMULA

=DATE(YEAR(TODAY()),12,31)

EXPLANATION

This formula uses the DATE, YEAR and TODAY functions to return the first day of a current year.

The TODAY function is used inside the YEAR function to derive with the year of today's date. This then forms part of the DATE function as the year parameter, with month parameter set to 12 and day parameter set to 31 to represent the last month and day of a year.

RELATED TOPICS

Related Topic Description Related Topic and Description
How to return the first day of a specific month
How to last day of a current month
How to calculate the first day of a current year

RELATED FUNCTIONS

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