I’m trying to create a Zap which schedules a meeting on the first working day of the next month.
I found this guide which explains how to check whether a date is on a weekend and hoped I could adapt that solution but it only seems to help manage weekdays for the current week, not another week in the future. So I’m not sure whether lookup tables are the solution here.
Can anyone suggest a way that I can get the first day of the next month, check whether it’s a weekday and get the date of the following Monday if it isn’t?
Best answer by SamBView original