The Excel Year function returns an integer representing the year of a supplied date.
The syntax of the function is:
where the serial_number argument is the date that you want to return the year of.
Note that Excel recommends that dates should be supplied to functions as either:
The following example shows the Year function used to extract the year from 3 different dates.
Further information and examples of the Excel Year function can be found on the Microsoft Office website.
The result of your Year function looks like a date (eg. "01/01/1900"), instead of returning an integer.
Most commonly, this problem arises because the new cell or column is formatted as a 'date'. In this case, it is only the formatting of the cell that is wrong, NOT the value returned by the function.
To correct this,