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

[mark.anley (Green Llamas Consulting)]

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.

Thanks
Mark

[JCorrell (Jim - The Monday Man)]

@mark.anley

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)

[mark.anley (Green Llamas Consulting)]

That did the trick Jim! Thanks!