Excel Function : YEAR

Download now!

Excel Function : YEAR

Category

Date and time

Description

Converts a serial number to a year

Microsoft Excel Reference Page

https://support.office.com/en-us/article/YEAR-function-c64f017a-1354-490d-981f-578e8ec8d3b9

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.