Please enable JavaScript to view the comments powered by Disqus.


SUM(...(...TEXT(...A1+ROW(...INDIRECT(..."A1:A"&A2-A1)),"DDD")<>"SUN")*1)

How to count working days excluding Sundays. 

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


Used Functions

Category: Math and trigonometry

Adds its arguments

Syntax

SUM(number1,[number2],...)

Category: 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])

Lets chat on this