Syntax
YEAR(Date)
Date (required) – This is the date value that you want to return the year from.
Example
In this example we use the function on several dates in different formats. Notice the text values we try result in a #VALUE! error while numerical values outside of the range 1 to 2,958,465 result in a #NUM! error.
