How to schedule reports to email monthly but only on weekdays
I use Supermetrics to send monthly reports to my clients. I usually schedule them to email on the 1st of the month, but would like to avoid sending on weekends and instead send on the closest weekday.
For ex. if the 1st of the month is a Sunday, I'd like the report to send out on Monday the 2nd.
I played around with using conditional emailing that refers to a cell which will display text if it's a weekday. I think this method would prevent emails from going out on weekends but not sure if the email will just not send that month or seek the next possible date that fulfills the condition.