Return first day of a current year
This tutorial shows how to calculate the first day of a current year using an Excel formula, with the DATE, YEAR and TODAY functions
GENERIC FORMULA
=DATE(YEAR(TODAY()),1,1)
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 and day parameters set to 1 to represent the first month and day of the current 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 |
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 |