YEAR Function

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

This example references the following sheet information:

 Clothing ItemTransaction TotalUnits SoldSold Date

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

=YEAR([Sold Date]1)Produces the year for row 1 of the Sold Date column 2023
=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 2023.) 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 2023.) Rows 1,2, and 3 apply.3,473

Still need help?

Use the Formula Handbook template to find more support, resources, view 100+ formulas, a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community