Hello! I already use automations with dates and formulas to set recurring tasks at daily, weekly, and monthly intervals. I have a task that occurs twice a week (ideally on tues/thurs). Is there a way to do this and avoid AT scheduling tasks on weekends or irregular days (tues/thurs one week and mon/wed another etc.) Thanks!
The WEEKDAY() function returns the day of the week for a given date, using a 0-6 range (0 = Sunday). The above formula will look at the weekday for a given date and add 2 days to it if it’s a Tuesday, and 5 days if it’s a Thursday. Wrapping this into an existing formula (if necessary) should be fairly straightforward, but feel free to ask for assistance if it’s not.