YEAR Function in Google Sheets

Extract the year from a date using the YEAR function in Google Sheets.

YEAR Function

The YEAR function in Google Sheets returns the year from a given date.

Syntax

YEAR(date)
  • date: The date from which to extract the year.

Examples

  1. Basic Usage

To extract the year from the date "2024-08-15":

=YEAR("2024-08-15")
  1. Using Cell Reference

If cell A1 contains a date, you can find the year with:

=YEAR(A1)

Notes

  • The function returns a four-digit year (e.g., 2024).
  • Useful for sorting, filtering, or grouping data by year.
  • MONTH: Extracts the month from a given date.
  • DAY: Extracts the day of

the month from a given date.