The following article details how to use the YEAR function, the function for the year value of a numeric expression.
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!