YEAR

See also A-Z Spreadsheet Function List

Description Returns the year that corresponds to the supplied date.

Syntax YEAR(serial_number)

serial_number is the date as a serial number or as text (e.g., “06-21-94” or “21-Jun-94”).

See Also DAY , HOUR , MINUTE , MONTH , NOW , SECOND , TODAY , and WEEKDAY functions

Examples YEAR(34328) returns 1993

         YEAR(“06/21/94”) returns 1994