YEAR Function and it's usage.

Syntax: 

=YEAR (date)

This function will help you get the year from a date. It will display a number representing year.

Arguments: 
date - A date from which to extract the year.

Usage notes: 
date - date must be a valid Excel date in serial number format. For example, the date Jan 1, 2000 is equal to the serial number 32526 in Excel

Excel only handles dates after 1/1/1900.

=YEAR(date)
If you need to extract the year from a date, you can use the YEAR function. In the generic form of the formula above, the date  must be in a form that Excel recognizes as a valid date.

Here's how the formula works:

The YEAR function takes just one argument, the date from which you want to extract the year. In the example, the formula is:

=YEAR(B4)

B4 contains a date value for July 7, 2016. The YEAR function returns the number 2016 representing the year of the date.

Note that you can use YEAR to extract the year from a day entered as text:

=YEAR("1/5/2016")

However, using text for dates can cause unpredictable results on computers using different regional date settings. In general it's better (and more flexible) to supply an address to a cell that already contains a valid date.