OK, all you smart people out there. (I know there are a lot of you!) I need a formula for my database and I need some help, (because I’m horrible with math and algebra.)
I have different churches with different services and studies through the week. The services are stored in the database with an unspecified date/day/time. (e.g. Bible study is every Tuesday night at 7:00pm) On an Airtable calendar I want to display an actual date to the user. (i.e. Tuesday, March 10th.) In order to do this I have to calculate what the next actual future date will be from whatever is the current date. It has to dynamically adjust with any given day the user might be looking at the calendar.
Not sure why my previous post is pending, but I’ve got something similar to this that I can share with you if you wish to reverse-engineer it and adapt it to your situation. I don’t have time to delve into the inner workings right now, although I do plan to share a how-to in some form (video, probably) at some unknown point in the future.