Creating Helper Column to Set a Date to reoccur annually
I am working on a project that tracks quarterly and annual filings. The date will vary depending upon the type of filing. I want to set it up so that reminders are sent automatically without a specific year in place. For example, a corporate annual report reminder date should be 6/30. Every year on 6/30, we want an automated notification to go to a designated person to file this annual report.
We are trying to avoid having to manually reset the year to the next year each time. I have been reading on the community site that helper columns can be set up to achieve this. However, I can't figure out how they work or how to set them up.
Any help is very much appreciated.
Help Article Resources
Check out the Formula Handbook template!