FUNCTION CATALOGUE / DATE & TIME
YEAR Excel function
Extracts the year from a date.
Correct sentence to use
Extract the year from [date].
Modify this query in PlainFormula →Example formula
=YEAR(A2)
Returns the year.
Syntax
YEAR(serial_number)
Argument signature: serial_number
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.