Workday INTL formula

[mdonovan890]

I am trying to create a WORKDAY.INTL formula that only includes Monday, Wednesday and Thursday excluding Saturday, Sunday,Tuesday and Friday. I am having a little trouble getting the "pattern" down. This is the formula I have but it is excluding Sat, Sun, Tue, Thur instead of Sat, Sun, Tue, Fri =WORKDAY.INTL(A1,7,"0101011")

 

[V_Malkoti]

Try this :

=workday.intl(a1,7,"010[COLOR=#0000ff]01[/COLOR]11")

Weekend pattern: "MTWTFSS"
Weekend string values are seven characters long and each character in the string represents a day of the week, starting with Monday.

 

[Dave Patton]

=workday.intl(a1,7,"0100111")