This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Workday with user-specified working days

Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hi all,

I need to compute a deadline given a starting date and the number of working days. I have already known that Airtable offers the formula WORKDAY(startDate, numDays, [holidays]) for such purpose. However, the formula automatically takes Saturdays and Sundays as non-working days but I need to specify others instead (in fact, my non-working days would be Sundays and Mondays).

Can anyone suggest any workaround for such situation?

Truly appreciate your time.

1 Comment
5 - Automation Enthusiast
5 - Automation Enthusiast

I would appreciate this too, as I compute deadlines similarly (weekends are not working days, but for the purposes of these deadlines, neither are Mondays or Thursdays).