@YEAR(date-number;[type]) extracts the year, an integer from 0 (1900) through 8099 (9999), from date-number.
date-number is an integer, or the address or name of a cell that contains an integer, from 1 (January 1, 1900) through 2958525 (December 31, 9999).
type is the number 0 or 1. If type is 1, @YEAR return the year in four-digit form. If type is 0 or omitted, @YEAR returns the offset of the year from 1900. For example, @YEAR returns 123 to represent the year 2023.
@YEAR can supply the year argument for other date @functions that build on previously calculated dates.
@YEAR(20181) = 55, because the date number 20181 is the date April 2, 1955.