Please enable JavaScript to view the comments powered by Disqus.


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

Counting if between given date range.

The formula uses COUNTIFS construction to apply multiple criteria on multiple lookup ranges to count the occurrences that meet the criteria returning the final count. 


Lets chat on this