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: