The YEAR function is a date and time function which takes "serial_number" as an argument and returns the year from the given date value. The year is returned as an integer in the range 1900-9999.
Formula:
=YEAR(serial_number) In the above syntax, the argument serial_number denotes the date of the year you want to find. Dates should be given as per the date function. Ex: Give the date as 17-6-1986 for the 17th day of June, 1986.
Video Tutorial:
Let us see how the YEAR function returns the year, with the help of the below video.