Auto populating meeting date
I am creating a policy database. Part of that database I have a submission form, committee members submit policies through this form when the policy is ready for the committee to review and vote on. I would like to auto populate the meeting date based on the submission or row certation. Eliminating manual work. Not sure if this is possible. We meet the 2nd Wednesday of every month. Ideally, I would like committee members to submit their documents 16 days before the meeting date. Any document submitted after that date it will roll over to the next month. For example. a policy is submitted between 12/26/2023 through January 29th will have a February 14th, 2024, date. Anything submitted January 30th through February 26th will have a March date. Is this possible?
Help Article Resources
Check out the Formula Handbook template!