Skip to main content

YEAR

Use the YEAR function to return the year from a Date or Date/Time. The year is a number ranging from 1000 to 9999.

Use

YEAR( date )
Returns the year of a date or date/time value.

ParameterRequiredDescription
dateYesthe date or date/time that contains the year to return

ReturnsNumber

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.

ON THIS PAGE