Count rows whose date falls between a start and end date.
Copy this formula
=COUNTIFS(D:D, ">="&E1, D:D, "<="&E2)COUNTIFS applies two conditions to the same date column — on or after the start (E1) and on or before the end (E2). Join the operator to the cell with &. Swap COUNTIFS for SUMIFS to total a value instead.
=COUNTIFS(Dates, ">="&DATE(2026,1,1), Dates, "<="&DATE(2026,3,31))→84Orders in Q1 2026.
You must concatenate: ">="&E1. Putting the cell inside quotes makes Excel treat "E1" as literal text.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.