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 from. This can be supplied to the Year function as either:
Warning: If you attempt to input the date argument as text, there is a chance that Excel may misinterpret this due to different date systems, or date interpretation settings.
The following example shows the Year function used to extract the year from 3 different dates.
Note that, in the above examples, as recommended by Microsoft, the serial_number argument is always supplied as either a reference to a cell containing a date, or as a value returned from another function.
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.
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,
- See the Excel Formatting page for more details on formatting in Excel.