Question: how to create a year formula in excel?
Answer: Summary. The Excel YEAR function returns the year component of a date as a 4-digit number. ... 
Get the year from a date.
Year as 4-digit number.
=YEAR (date)
date - A valid Excel date.
The YEAR function extracts the year from a given date as a 4-digit number. For example: