These docs are for v1.0. Click to read the latest docs for v1.2.

YEAR

Gets the year component of the specified date.

Syntax

=YEAR(date)

Arguments

ArgumentTypeDescription
dateDateThe date to use for calculation

Examples

=YEAR(DATE(2020, 2, 3, 4, 5))2020
Gets the year component 2020 from the specified date Feb 3, 2020 4:05 AM

=YEAR(DATE(2016, 4, 5, 6, 7))2016
Gets the year component 2016 from the specified date Apr 5, 2016 6:07 AM