It returns the year of a date, represented by a serial number. The year is given as an integer ranging from 1900 to 9999.
The syntax of the function is the following:
YEAR(serial_number)
serial_number: the serial number representation of a date
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the YEAR function:
In the cell range B2:D21, insert the appropriate functions so that
column B displays the day of the date appearing in column A,
column C displays the month of the date appearing in column A,
column D to displays the year of the date appearing in column A.