YEAR Function

Returns the year from a date as a four-digit number.
Sample Usage
YEAR([Due Date]5)
Syntax
YEAR(
  • date
)
  • date
    The date from which you want to return the year.
Examples

This example references the following sheet information:

  Clothing Item Transaction Total Units Sold Sold Date
1 T-Shirt 1,170.00 78 02/12/19
2 Pants 1,491.00 42 02/15/19
3 Jacket 812.00 217 02/20/19

Given the table above, here are some examples of using YEAR in a sheet:

Formula Description Result
=YEAR([Sold Date]1) Produces the YEAR for the “Sold Date” column on row 1. 2019
=SUMIF([Sold Date]:[Sold Date], YEAR(@cell) = YEAR(TODAY()), [Units Sold]:[Units Sold]) Sums the total amount of “Units Sold” for the current year. (In this example, the year is 2019.) Rows 1, 2, and 3 apply. 337
=SUMIF([Sold Date]:[Sold Date], YEAR(@cell)=YEAR(TODAY()), [Transaction Total]:[Transaction Total]) Sums the total amount of "Transaction Total" for the current year. (In this example, the year is 2019.) Rows 1,2, and 3 apply. 3,473