COUNTIFS(...)
How to countif between given range of dates.
Used Functions
Category: Statistical
Counts the number of cells within a range that meet multiple criteria
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Practice COUNTIFS Formula at Sheetzoom
COUNTIFS formula at Microsoft help
0
The COUNTIFS function requires two arguments as criteria, first is used as a lower bound making sure that no date is lower the it, and the upper bound being second criteria to confirm that every thing is less then it. Besides, there are two lookup ranges to get the count.