Formulas and Functions
YEAR
The YEAR function returns the year for a given date/time value or date string.
YEAR(date)
date: A given date/time value or date string.
Examples |
|---|
=YEAR("4/6/88 11:59:22pm") returns 1988. =YEAR(NOW()) returns the current year. For example, 2020 is returned when calculated anytime during 2020. |