Returns the year as a number according to the internal calculation rules.YEAR(Number)Number shows the internal date value for which the year is to be returned.=YEAR(1) returns 1899=YEAR(2) returns 1900=YEAR(33333.33) returns 1991=YEAR(DATEVALUE("2010-09-28")) returns 2010.YEAR wiki page.