Examples
YEAR(TODAY()) : This year. See also TODAY().
YEAR(TODAY()) + 1 : Next year.
YEAR(TODAY() + 365) : Next year (unless today is January 1 of a leap year).
YEAR(TODAY()) - 1 : Last year.
YEAR([Birthday]) : Someone's birth year.
Syntax
YEAR( when )
Arguments
- when (Date, DateTime, or Time)
Return Value
Number: the year specified by when if identifiable, a fixed default year if when is a Time value, or 0 if a year is otherwise not found.