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.