I'm not very experienced with google sheets formulas, and I'm attempting to create a rolling year formula for a scholarship spreadsheet. All I really need it to do (if it's even possible) is to automatically update the year once the date listed in a column has passed. For example, if the date is 2/1/2022 and that date has passed it just needs to update to 2/1/2023. EDATE has seemed like the most effective solution for this, but it would have to be manually done once a year and I will no longer be working in this position by next year and won't be here to update it myself. So I am attempting to automate the sheet so I won't have to leave instructions on just how to update the dates. This is for ease of use and so that the sheets can be continued to be used without having to manually update 100s of dates every year. I appreciate any and all suggestions!
This is a link to the copy of the spreadsheet in case it's helpful: https://docs.google.com/spreadsheets/d/1h4EaqqwvqszvHt3X1Agm-8gLIjbgPgh8OMDizi7ZDnY/edit?usp=sharing