With default tweaks, 1 = Sunday and 7 = Saturday.
So, 2 = Monday, 6 = Friday, and so on.
For example, January 1, 2016 is the serial number 42370, and January 8 is 42377.
Dates in Excel only look like dates when a date number format is applied.
By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, but this is configurable.
you’re able to use the WEEKDAY function inside other formulas to check the day of week.
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.
SUMPRODUCT Function
The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.
The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.
