<< Click to Display Table of Contents >> YEAR (year of a date) |
Syntax:
YEAR(Date)
Description:
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