Workday with user-specified working days


#1

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.


#2

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).