Skip to main content

YEAR

The YEAR function returns the year component of a date as a 4-digit number.

Syntax​

=YEAR(serial_number)

Parameters​

  • serial_number: The date from which you want to extract the year

Examples​

=YEAR("2025-04-21") // Returns 2025
=YEAR(DATE(2024, 12, 25)) // Returns 2024
=YEAR(TODAY()) // Returns the current year