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

DAY()

MONTH()

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