YEAR

Definition: The YEAR function in Excel is used to extract the year from a date.

Syntax: ==YEAR(serial_number).

Situation: This formula is appropriate in situations where you need to extract the year from a date.

Example: If you have a date in cell A1 that is January 1, 2022, you would use the formula =YEAR(A1). This would return a value of 2022, which is the year of the date in cell A1.