Monday, Tuesday, etc.)
for every day between the two given dates.
WEEKDAY returns a number between 1 and 7.
With default tweaks, Sunday=1 and Saturday = 7.
The trick to this formula is assembling an array of dates that you could feed into the WEEKDAY function.
Note the values in this array are text, not numbers.
The math operation coerces the text to numeric values.
MATCH returns a number when holidays are found and the #N/A error when not.
The ISNA function “flips” the results so that TRUE represents holidays and FALSE represents non-holidays.
For example, =MID(“apple”,2,3) returns “ppl”.
ROW Function
The Excel ROW function returns the row number for a reference.
For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.
When no reference is provided, ROW returns the row number of the cell which contains the formula.
INDIRECT Function
The Excel INDIRECT function returns a valid cell reference from a given text string.
INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.
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.
SUMPRODUCT Function
The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.
