@YEAR

@YEAR(date-number;[type]) extracts the year, an integer from 0 (1900) through 8099 (9999), from date-number.



Arguments

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.



Notes

@YEAR can supply the year argument for other date @functions that build on previously calculated dates.



Examples

@YEAR(20181) = 55, because the date number 20181 is the date April 2, 1955.



See Also
@DAY extracts the day of the month (1 to 31).
@MONTH extracts the month (1 to 12), from a date number.
More power with @functions
@functions A-Z
Why do I need different number formats
More power with @functions
@functions A-Z