Weekday automation only

I must be missing something totally obvious since I can’t find any other post addressing this topic.

I set up an automation to send an email every morning but I only need it to go out on weekdays, not weekends.

What’s the best way to accomplish this?

Bonus if you can help me figure out how to avoid this automation going off on holidays.

Thanks in advance for your time.

If you setup a time baseed automation, you should be able to select the days you’d like it to repeat!

For holidays, you could search online for a 2022 holiday list csv, import it as a table, and make sure the date column is a date column.

Then you could use the If section on the automation so that it runs only if the current date is not in the HolidayTable date column.

The formula would look something like

Today().In([HolidayTable].[Date]).Not()

1 Like

Omg I knew this was a dumb blockage. I was using the day option and not the week option. Thank you for the quick help and the bonus formula.

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