
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 30, 2022 02:53 AM
Is it possible to make an automation to send out an email every third Monday of the month? I was only able to find ways to send out the email every certain day or time of the month, but not a specific third weekday. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 30, 2022 04:12 AM
Hi Callie, to do this I would create two automations:
- The first automation will run once a month, on the first day of the month, and it will create a new record with that day’s date (e.g. 1 May 2022)
- The second automation will trigger off of a record matching a condition, in this case, detecting whether it’s the third Monday of the month
To get the third Monday of the month, we would modify the formula provided by @Kamille_Parks in this thread, and the following is what I came up with (mistakes my own):
DATEADD(
Date,
SWITCH(
WEEKDAY(Date),
0, 15,
1, 14,
2, 20,
3, 19,
4, 18,
5, 17,
6, 16
),
"days"
)
I’ve created a base with the automations and formula set up here. To view the setup (formulas, automations etc), duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 31, 2022 03:29 AM
Thank you so much for replying so quickly, this was a big help!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 16, 2025 07:40 AM
How would I modify this formula to get the first Thursday of each month? I am confused on how to determine this string:
0, 15, 1, 14, 2, 20, 3, 19, 4, 18, 5, 17, 6, 16
