Please enable JavaScript to view the comments powered by Disqus.


SUM(...(...TEXT(...B4+ROW(...INDIRECT(..."A1:A"&(...B5-B4))),"DDD")="FRI")*1)

Calculate Friday's between two dates

The formula takes the difference of two dates and adds it up in the start date to get all the dates in the range. Then it uses TEXT() function to format it as first three letters of the day and then perform match and sum the count.


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