YEAR function

The YEAR function is one of the date and time functions. It returns the year (a number from 1900 to 9999) of the date given in the numerical format (MM/dd/yyyy by default).

Syntax

YEAR(serial_number)

The YEAR function has the following argument:

Argument	Description
serial_number	The date of the year you want to find.

Notes

How to apply the YEAR function.

Examples

The figure below displays the result returned by the YEAR function.