YEAR Function Explained
The YEAR Function in Microsoft Excel returns the year component of a given date. It takes a single argument, which is a date in the form of a serial number, and returns a four-digit year number. For example, YEAR(40000) returns 2020.
YEAR Function Syntax
YEAR(serial_number)
- serial_number: The date of the year you want to find the year of.