Skip to main content

Workday with user-specified working days

  • September 5, 2017
  • 1 reply
  • 14 views
I
Forum|alt.badge.img+2

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.

    Calvin_Young2

    1 reply

    B

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

    Terms & ConditionsAccessibility statement