Skip to main content

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!

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.

Reply


Terms & Conditions