What is the use of YEAR function?

Returns the year of a date.
Note: The year is returned as an integer in the range 1900-9999

What is the syntax of YEAR function?

YEAR Function in Excel-syntax

YEAR(serial_number)

Where Serial_number: is the date of the year you want to find.

YEAR Function in Excel – Examples

YEAR Function in Excel- Example 1

Reference:

Please refer the below article for more Date & Time Excel functions.
Date & Time Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

Hey! Join Our Community

Get Quick Responses & Experts' Answers in Minutes!
Get Notified - When Answered Your Question!