YEAR

The YEAR Function

Function Group: Date

YEAR takes a date and returns a four-digit integer representing the year on which it falls.

Syntax

YEAR(arg1)

• arg1 is a date object or a function that resolves to a date object

Uses

To get the current year, we can call YEAR with an argument of a date object.

For instance, if we want to find the current year, we can call YEAR(TODAY()), with the TODAY function being the argument. This returns a four-digit integer representing the current year.

If the current date were April 27th, 2099, YEAR(TODAY()) would return 2099.