YEAR()

Returns the year (Number value) from Date, DateTime, or Time. If a Time value is specified, which has no year component, returns a default year. If the specified value is not a Date, DateTime, or Time value, returns a blank.

Sample usage

YEAR(TODAY()) returns this year. See also: TODAY()

YEAR(TODAY()) + 1 returns next year.

YEAR(TODAY() + 365) returns next year (unless today is January 1 of a leap year).

YEAR(TODAY()) - 1 returns last year.

YEAR([Birthday]) returns someone's birth year.

Syntax

YEAR(when)

• when - A Date, DateTime, or Time value.

See also

DAY()

MONTH()