SUM(...)
How to count working days excluding Sundays.
Used Functions
Category: Math and trigonometry
Adds its arguments
Syntax
SUM(number1,[number2],...)
Practice SUM Formula at Sheetzoom
SUM formula at Microsoft helpCategory: Text
Formats a number and converts it to text
Syntax
TEXT(Value you want to format, “Format you want to apply to that value”)
Category: Lookup and reference
Returns the row number of a reference
Syntax
ROW([reference])
Category: Lookup and reference
Returns a reference indicated by a text value
Syntax
INDIRECT(ref_text, [a1])
0
The formula checks for each date if it is Sunday using TEXT() function and then return and array of zero and ones that is summed up to give you the answer