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(serial_number)
Where Serial_number: is the date of the year you want to find.
YEAR Function in Excel – Examples
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