Kornilios Ampatzis/ April 25, 2019/ Functions

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:

Practice

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.

Share this Post