### YEAR(serial_number)

Returns the year as an integer given a date serial number.

 serial_number The date that contains the year you want to find.

#### Remarks

 * The "serial_number" can be a date value, a serial number or a reference to a cell containing a date.* If "serial_number" < 0, then #NUM! is returned.* If "serial_number" is not a valid date, then #VALUE! is returned.* You can use the DATE function to return the date as a date serial number given a year, month, day.* You can use the DATEVALUE function to return the serial number representing a date in a text format.* You can use the DAY function to return the day as an integer given a date serial number.* You can use the MONTH function to return the month as an integer given a date serial number.* You can use the NOW function to return the serial number of the current system date and time.* You can use the TODAY function to return the serial number of the current system date. * You can use the YEARFRAC function to return the number of years as a decimal between two dates.* For the Microsoft documentation refer to support.office.com

 A B 1 =TODAY() = Friday, November 13, 2020 01 July 2003 2 =NOW() = Friday, November 13, 2020, 16:03 =NOW() = 13/11/2020 3 =YEAR(B1) = 2003 =NOW() = 44149 4 =YEAR("01 July 2003") = 2003 5 =YEAR(B2) = 2020 6 =YEAR(38093) = 2004 7 =YEAR(DATE(1977,7,1)) = 1977 8 =YEAR(0) = 1900 9 =YEAR(-10) = #NUM! 10 =YEAR("some text") = #VALUE!

 1 - What is the current system date. This cell has been formatted with the number format "dddd, mmmm dd, yyyy".2 - What is the current system date and time. This cell has been formatted with the number format "dddd, mmmm dd, yyyy, hh:mm".