Functions
YEAR
Year from a date serial number
Try it
When to use it
What does YEAR return?
YEAR takes a date and returns its four-digit year as a number, which you can use in comparisons, grouping, or further calculations.
How do I group records by year?
Apply YEAR to each date to get the year number, then use it as the key in a SUMIF, COUNTIF, or pivot to roll figures up by year.
Use cases
Find the year a contract started
Extract the reporting year
Used in
Syntax
YEAR(date)Examples
=YEAR(DATE(1969,7,20)) // => 1969
=YEAR(40909) // => 2012
=YEAR(DATE(2020,2,29)) // => 2020