Help

Re: Recurring tasks forTuesdays and Thursdays

639 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Harrison_Rice
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Reply 1

Yes, this is doable. Here’s the basic formula:

DATEADD(
    Date, SWITCH(
        WEEKDAY(Date),
        2, 2,
        4, 5
    ), "days"
)

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.