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

**URL:** <https://community.make.com/t/get-a-future-date-that-falls-on-a-specific-day-of-week-from-a-date-variable-e-g-now/84657>\
**Category:** Questions\
**Tags:** date-time-functions, functions\
**Created:** [June 11, 2025, 7:34am UTC](https://community.make.com/t/get-a-future-date-that-falls-on-a-specific-day-of-week-from-a-date-variable-e-g-now/84657 "2025-06-11T07:34:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![m\_m](https://avatars.discourse-cdn.com/v4/letter/m/9fc29f/32.png) [@m\_m](https://community.make.com/u/m_m)\
**Post date:** [June 11, 2025, 7:34am UTC](https://community.make.com/t/get-a-future-date-that-falls-on-a-specific-day-of-week-from-a-date-variable-e-g-now/84657/1 "2025-06-11T07:34:54Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![JaceB](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/jaceb/32/73963_2.png) [@JaceB](https://community.make.com/u/JaceB)\
**Post date:** [June 12, 2025, 7:19pm UTC](https://community.make.com/t/get-a-future-date-that-falls-on-a-specific-day-of-week-from-a-date-variable-e-g-now/84657/2 "2025-06-12T19:19:46Z")

</div>

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.

1. 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.

1. 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!

```auto
{{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

```auto
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:

```auto
[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.

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [June 13, 2025, 7:48am UTC](https://community.make.com/t/get-a-future-date-that-falls-on-a-specific-day-of-week-from-a-date-variable-e-g-now/84657/3 "2025-06-13T07:48:32Z")

</div>

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):

[![Screenshot 2025-06-13 154612](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/f/df16132aff632ee5e63cb4d5675d7b2d768d6c55.png)](https://community.make.com/t/free-app-my-toolbox-of-useful-modules/80159)

[![Screenshot 2025-06-13 154706](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/e/aec8f534112ebd58a56c6b8e68084597fe51ff9b.png)](https://community.make.com/t/free-app-my-toolbox-of-useful-modules/80159)

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](https://community.make.com/t/free-app-my-toolbox-of-useful-modules/80159)**

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](https://academy.make.com) will save you lots of time and frustration using Make!

— @samliew

---

<div class="post-metadata">

**Author:** ![m\_m](https://avatars.discourse-cdn.com/v4/letter/m/9fc29f/32.png) [@m\_m](https://community.make.com/u/m_m)\
**Post date:** [June 12, 2025, 2:05pm UTC](https://community.make.com/t/get-a-future-date-that-falls-on-a-specific-day-of-week-from-a-date-variable-e-g-now/84657/4 "2025-06-12T14:05:22Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [June 30, 2025, 8:40am UTC](https://community.make.com/t/get-a-future-date-that-falls-on-a-specific-day-of-week-from-a-date-variable-e-g-now/84657/5 "2025-06-30T08:40:38Z")

</div>

> [@m\_m](#):
>
> Is there a clean way to write this logic using `addDays()` and `formatDate()` in Make?

Unfortunately not, hence my module exists.

> [@m\_m](#):
>
> always falls on the Wednesday of the third week starting from today.

Give the module above a try, setting the day of week to “Wednesday”, and use the index `3` on the resulting array `nextDatesOfWeek`.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [July 14, 2025, 8:42am UTC](https://community.make.com/t/get-a-future-date-that-falls-on-a-specific-day-of-week-from-a-date-variable-e-g-now/84657/6 "2025-07-14T08:42:30Z")

</div>