Please enable JavaScript to view the comments powered by Disqus.


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

How to countif between a date range

Here COUNTIFS take two arguments as criteria, one as a lower bound ensuring that no date is selected lower to it, and the upper bound as second criteria to make sure every thing is less then it. There are two lookup ranges respectively to get the count.


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