YEAR

YEAR is a function in excel that returns the four-digit year component of any date in a data set. Regardless of the format of the date, the YEAR function can extract the year value. This is commonly used in financial models when displaying the periods of certain historical or projected data.