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!