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.

See Also

DAY(), MONTH()

Did this answer your question?