The COUNTIFS formula is used to count number of cells in a specific criteria. Here we will learn how to count cells between two dates using COUNTIFS formula.

Sometimes we have a multiple ranges of dates. To count cells between two dates we use this formula.

1. To start formula type = (Equal).
2. Type Countifs.
3. Start ( (Bracket).
4. Select Range of dates.
5. Type , (comma).
6. Type ” (Inverted comma).
7. Type > (Greater sign).
8. Type = (Equal).
9. Type the Start Date (mm/dd/yyyy).
10. Close ” (Inverted Comma).
11. Type , (Comma).
12. Select Range of dates again.
13. Type , (Comma).
14. Star ” (Inverted Comma).
15. Type < (Less than).
16. Type = (Equal).
17. Type the end date (mm/dd/yyyy).
18. Close ” (Inverted Comma).
19. Close the Bracket.

For example:

We have a range of dates between 01/02/2020 to 06/06/2020, and we want to know that how many cells are there between given dates.