YEAR - the Function for the Value Is the Year of a Numeric Expression in

This guide provides a practical overview of YEAR - the Function for the Value Is the Year of a Numeric Expression in, including its main features, benefits, limitations, and important considerations.

Description: The function returns the year of any date value, the year value is an integer between 1900 and 9999.

Syntax : YEAR (serial_number) .

Inside:

serial_number : is the date value in the year to search, is a required parameter.

For example:

Calculate year values in different date formats in the following table:

In the cell to calculate enter the formula: = YEAR (C7) .

Press Enter -> the year value in the date value is:

Similarly copy the formula for the remaining cells to get results:

So with many different date formats but the HOUR function gives accurate results.

Above is how to use as well as some common cases using the HOUR function.

Good luck!