YEAR function

YEAR(date) returns the year of date. Date can either be a serial date number or a date string.

Example

YEAR("08.23.88") returns 1988 (date format MM.DD.YY)

YEAR(TODAY()) returns today's year.

Calculator

Related functions

• DAY function
• MONTH function
• List of Date and time functions