If the Excel YEAR function is not working on your Windows 11/10 PC, change the cell format, convert text dates to real dates, remove hidden spaces from dates, etc.
AGGREGATE was built to handle messy data from the start.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results