Returns numeric YEAR value. Year function is very useful in Excel when you wish to extract only Year from a date. Year function takes one parameter serial_number, and returns the year of given date, an integer in the range of 1900 to 9999.
- serial_number: refers to a valid date from which year needs to be extracted.
Next >> MONTH Function in Excel with example