YEAR() : extract the year from a date

In a formula-type column, the YEAR() function displays the year from a date-type column, and returns a 4-digit number. It is used as an annual key: comparing volumes year over year, archiving by fiscal year.

Syntax

YEAR(date_column)

Parameters

# Parameter Description

1 date_column The date-type column from which you want to extract the year.

The output format of the column can be chosen in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.

Examples

Extract the year from a date

YEAR($Date)

For a date in 2022, the column returns 2022.

Combine YEAR() with MONTH(), WEEK(), or QUARTER() to build chronological grouping keys.

Go further

QUARTER

Extract only the quarter from a date.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.