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

EXCEL FORMULA 1. Return first day of a current year

EXCEL

Return first day of a current year

=DATE(YEAR(TODAY()),1,1)
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
How to return the first day of a specific month
How to last day of a current month

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