<< Click to Display Table of Contents >> YEAR (year of a date)

Syntax:

YEAR(Date)

Description:

This returns the year of a date.

Example:

YEAR("09/25/2018") returns 2018

If cell A1 contains the date value 9/25/2018: YEAR(A1) returns 2018

See also:

ISOWEEKNUM, ISOWEEK, WEEKNUM, MONTH, DAY, DAYSPERYEAR, WEEKDAY