Extracts the year from a date, so YEAR of 15 December 2024 is 2024. It is the companion of DAY and MONTH.
When to use
Subtracting YEAR values is crude: 31 December 2023 to 1 January 2024 is one day but the year difference is 1. Use DATEDIF for complete years.
See Lec 04.