YEAR()

Year from Date, DateTime, or Time

Returns the year (Number value) from DateDateTime, or Time. If a Time value is specified, which has no year component, returns a default year. If the specified value is not a DateDateTime, 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

Date and time expressions

DAY()

MONTH()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false