YEAR - The function returns the year corresponding to a date in Excel

The following article introduces you to the YEAR function - one of the functions in the date and time group function is very popular in Excel.

YEAR - The function returns the year corresponding to a date in Excel Picture 1

Description: The function returns the year value corresponding to a date in Excel. The year value is an integer between 1900 and 9999.

Syntax: YEAR (serial_number).

Inside:

- serial_number: Date to search for the year value, is a required parameter.

Attention:

- Excel stores the date as a serial number to facilitate the calculation process.

- The value returned in the YEAR function will be a Gregorian value regardless of the format.

For example:

Calculate the corresponding annual value of the following specific dates:

YEAR - The function returns the year corresponding to a date in Excel Picture 2

- In the cell to calculate enter the formula: = YEAR (F7)

YEAR - The function returns the year corresponding to a date in Excel Picture 3

- Press Enter -> the corresponding year is:

YEAR - The function returns the year corresponding to a date in Excel Picture 4

- Similarly copying the formula for the remaining values results:

YEAR - The function returns the year corresponding to a date in Excel Picture 5

- In case of incorrect input value serial_number -> function returns error value #VALUE!

YEAR - The function returns the year corresponding to a date in Excel Picture 6

Above are instructions and some specific examples when using the YEAR () function in Excel.

Good luck!

Lesley Montoya

Update 19 May 2020

You should read it

May be interested

YEARFRAC function - The function returns the fifth calculated by the number of whole days between two specific dates in Excel
yearfrac function: the function returns the fifth calculated by the number of whole days between two specific dates in excel. syntax: yearfrac (start_date, end_date, [basis])
NETWORKDAYS.INTL function - The function returns the number of whole working days between 2 dates, specifying weekends in Excel
networkdays.intl: the function returns the number of whole working days between two dates by using a parameter that determines the number of weekends and which day of the week. syntax: networkdays.intl (start_date, end_date, [weekend], [holidays])
DATEDIF function - The function calculates the number of days, months, years between 2 dates in Excel
datedif function: the function performs the calculation of number of days, months, years between 2 dates in excel. functions are useful in formulas for calculating age numbers. syntax: datedif (start_date, end_date, unit)
DATEVALUE function - Functions to convert text format dates to serial numbers in Excel
datevalue function: the function converts the stored date value as text into a serial number recognized by excel. the function is useful in cases where the worksheet contains the date format you want to filter or sort. syntax: datevalue (date_text)
DAY function - The function returns the date value of a specific date in Excel
the day function: the function returns a date value in a specific date, month, and year format in excel. syntax: day (serial_number)
The DAYS function - The function returns the number of days between 2 dates in Excel
days function: the function returns the number of days between 2 dates, the support function from excel 2013 onwards. syntax: days (end_date, start_date)

YEAR - The function returns the year corresponding to a date in Excel

You should read it

May be interested

Office information