Question: what is the formula for year in excel?
Answer: Excel YEAR function =YEAR(A2) - returns the year of a date in cell A2. =YEAR("20-May-2015") - returns the year of the specified date.