This article describes two different ways of solving this problem.
The second method is based on the WEEKDAY function.
This is the “traditional approach”, although I find it harder to understand.
Both approaches are explained below, and both work equally well.
The text string “ddd” is acustom number formatfor a 3-letter abbreviation for weekday names.
There is no need to know the numeric values for each day, as with the WEEKDAY formula below.
WEEKDAY option
Another more traditional way to solve this problem is with theWEEKDAY function.
The WEEKDAY function takes a date and returns a number between 1-7 representing the day of the week.
This formula is more difficult to understand than the first formula.
The third argument in WORKDAY.INTL isweekend, which specifies which days of the week should be treated as weekends.
MATCH supports approximate and exact matching, andwildcards(* ?)
in a text string with the number format of your choice.
By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, but this is configurable.
