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.


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