Explanation
You might wonder why we aren’t usingCOUNTIForCOUNTIFS.
These functions seem like the obvious solution.
This makes it easier to list the days in order with the numbers in column E in sequence.
WEEKDAY evaluates each date indates(B5:B15) and returns a number.
Without day numbers
The day numbers in column E make the formula easier to understand and write.
By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, but this is configurable.
it’s possible for you to use the WEEKDAY function inside other formulas to check the day of week.
MATCH supports approximate and exact matching, andwildcards(* ?)
Often, MATCH is combined with the…
