Having a Date Returned from an Automation move to the next Business Day with General Caster

Hi All - need a bit of Formula help here. I am utilizing General Caster in attempts to ensure dates that are being set via automations always land on a business day (no weekends or holidays). As an example, on the first of the month a series of automation will run to se dates on the 3rd business day, 5th business day, or the 15th of the month. If any of these land on weekends or holidays, it should move to the next business day.

This is being completed in GC as I need to utilize the date column afterwards for further automations.



This should do it:
TEXT(WORKDAY(DATEVALUE({item's Intro Call Date})-1,1,{"2022-07-18","2022-07-19"}),"YYYY-MM-DD")

The holidays ({“2022-07-18”, “2022-07-19”}), of course, should be adjusted to your specific needs.

Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you?
We Create Custom Solutions
Schedule a 1-on-1 Tutorial Session (for monday, Make & Favorite Colors)


That did the trick Jim! Thanks!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.