YEAR

The YEAR function extracts the year from a date. This function is commonly used to group, filter, and analyze data by year.

Syntax

YEAR(date)

Arguments

• date: The input date.

Return value

Returns the year as a number.

Example

YEAR("03/21/2026")

Returns 2026.