Returns the Year component of a given date.
The Excel YEAR function extracts an integer after 1900 that corresponds to the Year component of a given date. Example; to get or find Year from a date (11/08/2017- cell B5), use =YEAR(B5), that returns ‘2017’.
Isolating the year part of a date is useful if application where only year component is required in a specific argument.
Serial_number – A valid argument of date, string representation or a serial number of a specific date.
An Integer representing year component of a date.
- A valid date format in the function may be entered in time, text and serial number format in the specific cell of the worksheet.
- Use YEARFRAC function returns a proportion of a year representing the number of whole days.
- As with all dates in Excel, what you end up with is a serial number, but the Date formatting displays the date in a readable fashion.
- Excel accepts two different Date System, return #VALUE! error in case you enter a date before January 01, 1900 for Windows and January 1, 1904 for Macintosh.