Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Recurring tasks forTuesdays and Thursdays

Topic Labels: Formulas
224 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.