Please enable JavaScript to view the comments powered by Disqus.


COUNTIFS(...B4:B11,(...">="&B13),B4:B11,(..."<="&B14))

Using countif to count between date range

We actually use COUNTIFS() to count for such cases, it takes multiple lookup ranges and multiple criteria with logical operators to give the result


Used Functions

Category: Statistical

Counts the number of cells within a range that meet multiple criteria

Syntax

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Lets chat on this