If the Excel YEAR function is not working on your Windows 11/10 PC, change the cell format, convert text dates to real dates, ...
From hidden rows to sheet protection passwords, Excel's "privacy" features are easily bypassed—encryption and deletion are much more watertight.