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
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 |
---|---|---|
Return first day of a month | How to return the first day of a specific month | |
Return last day of a current month | How to last day of a current month | |
Return first day of a current year | How to calculate the first day of a current year |
RELATED FUNCTIONS
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 | |
TODAY Function | The Excel TODAY function returns the current date |