Exercises / Dates and deadlines · 9 of 10
Count orders between two dates
To count within a date range, give COUNTIFS the same date column twice: once with ">="&start and once with "<="&end. Keep the dates in cells so the period is easy to change.
Your taskIn F3, use COUNTIFS to count the orders in A2:A13 dated from F1 to F2, both dates included.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Date | Order | Amount | From | 15 Mar 2026 | |
| 2 | 2 Mar 2026 | #01 | $120.00 | To | 31 Mar 2026 | |
| 3 | 9 Mar 2026 | #02 | $85.00 | Orders | ||
| 4 | 15 Mar 2026 | #03 | $240.00 | |||
| 5 | 18 Mar 2026 | #04 | $60.00 | |||
| 6 | 22 Mar 2026 | #05 | $310.00 | |||
| 7 | 29 Mar 2026 | #06 | $95.00 | |||
| 8 | 31 Mar 2026 | #07 | $150.00 | |||
| 9 | 3 Apr 2026 | #08 | $75.00 | |||
| 10 | 11 Apr 2026 | #09 | $420.00 | |||
| 11 | 19 Apr 2026 | #10 | $55.00 | |||
| 12 | 30 Apr 2026 | #11 | $180.00 | |||
| 13 | 2 May 2026 | #12 | $260.00 |