How to Use Excel YEAR Function
ExcelOffice

How to Use Excel YEAR Function

The Excel YEAR function extracts the year from a given date as number between 1900 to 9999. You can use the YEAR function to extract a year number from a date into a cell, or to feed a year number into another function like the MONTH function.

1. Learn about the Excel YEAR function

Syntax:

=YEAR(serial_number)

Where serial_number is any valid Excel date of the month.

The Excel YEAR function extracts the year from a given date as number between 1900 to 9999. For example, given the date “Jul 08, 2020”, the YEAR function will return 7 for July.

Dates can be supplied to the YEAR function as text (e.g. “10-Nov-2021”) or as native Excel dates, which are large serial numbers.

2. Examples of Excel YEAR function

=YEAR(“16-Jul-2019”) // returns 2019

=YEAR(“06-Aug-2020”) // returns 2020

With the date “November 23, 2021” in cell A2, YEAR returns 2021:

=YEAR(A1) // returns 2021

Note: dates are serial numbers in Excel, and begin on January 1, 1900. Dates before 1900 are not supported.

3. Common errors when using the YEAR function in Excel

YEAR will return #VALUE! if a date is not recognized. Please enter exactly what the function requires is day, month, year in numbers.

How to Use Excel YEAR Function

YEAR will return #NAME? if you entered the error value is a letter or a character. For example: YEAR(AA), YEAR(A@)

YEAR will return #NUM! if a date is supplied as a number that is out of range (i.e. 1800).

See Also:  How to Use Excel MONTH Function

Leave a Reply

Your email address will not be published.

Back to top button