Skip to Content

YEAR

Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999

Syntax

YEAR(serial_number)

Parameters

  • serial_number: Required. The date of the year you want to find

Example

=YEAR("1/15/2024")
Returns: NumberSince: Excel 2003