As a side note, I usually do this kind of thing in my preferred database / table tool Coda so for this process, I am trying to do it all in Make via formulas. It’s not the exact but hopefully gives you some guidance and answers your question.
So I would first set 2 variables for the current month 3rd Wednesday and the next month’s third Wednesday. I would set it the DD=21, because it will choose the closest Wednesday around that third week. ThisThirdWeds: setDay(YY-DD-MM;4) NextThirdWeds: setDay(YY-DD-MM+1;4)
This will give us two options before we calculate the days, our wanted Weds will be either this or next month depending on today’s date.
Then you will create a variable via the switch module I will call this 3rdWeds
Using the an if statement compare todays’s date with one of the options. You can do this multiple ways. One way is to extract the month, compare the two, then the day.
I used this to extract the month as a number but feel free to do what you want!
So the logic is below.
If today’s date is BEFORE ThisThirdWeds then 3rdWeds = ThisThirdWeds. If today is after
then 3rdWeds = NextThirdWeds
Pseudocode example so apologies formatting
Now we have our Wednesday date. The next would be calculating the days between today and your 3rdWeds . This would be various ways, but you if you have different months between today and your 3rdWeds date, you have to do:
[ 3rdWedsDD+ ( Days in Today's Month )] -TODAYDD = Days from Today
So let’s say today is June 19, 2025, so your next 3rdWeds is July 20, 2025 . You have to adjust the day of 20 to really be 30+20 or 50. Because it’s 20 days after the end of June. So when you find the difference it’s 50-19 = 31 or 31 days from today, not the incorrect 20-19.
Again the usual formulas I use are in like Airtable or Coda so I apologize if there are some holes missing from this response.
Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!