Get a future date that falls on a specific day of week from a Date variable (e.g.: now)

m_m · June 11, 2025, 7:34am

I’m trying to calculate a date that always falls on the Wednesday of the third week starting from today.

Important:
I don’t mean “exactly 21 days from now” – I specifically want the Wednesday in the third calendar week starting from today.

Example:

If today is Friday, then “Wednesday in 3 weeks” would be 19 days from today
If today is Monday, it would be 23 days from today**
The logic should always find the Wednesday that belongs to the third week (not a fixed number of days)

Is there a clean way to write this logic using addDays() and formatDate() in Make?

Thanks a lot!

JaceB · June 12, 2025, 7:19pm

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!

{{parseNumber(substring(formatDate(now; "MM-DD-YY"); 0; 2); ".")}}

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

if(TODAYMM<=THISWEDMM){
   if(TODAYDD<=THISWEDD){
       3rdWeds = ThisThirdWeds;
    }
      else 
       {3rdWeds= NextThirdWeds;}
 }
else 
  {3rdWeds =NextThirdWeds;}

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.

samliew · June 13, 2025, 7:48am

Have you tried my “Get Dates for Day of Week” module?

Here is an example of the next year’s worth (52 weeks) of dates that fall on “Wednesday”, from today (Friday, 13 June):

This free custom app is made with <3 for the Make community.

You can read more about my custom app and how to install it here: [Free App] My Toolbox of Useful Modules

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!

— @samliew

m_m · June 12, 2025, 2:05pm