YEAR Function

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.

Learn MS Excel


Ask Questions

Ask Question