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!
Recurring tasks forTuesdays and Thursdays
+21Yes, 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.