Excel Function : YEAR

Download now!

Excel Function : YEAR


Date and time


Converts a serial number to a year

Microsoft Excel Reference Page


Syntax and Description of the YEAR Excel Function

The YEAR function in Excel returns the year component of a date as a number between 1900 and 9999. The syntax of the YEAR function is as follows: YEAR(date) where date is a valid date.

About YEAR Excel Function

The YEAR function returns a four-digit year (a number from 1900 to 9999) given a date value.