COUNTIFS between Two Dates
Counting records inside a date window is much easier with COUNTIFS than with manual filters. You set a lower date limit and an upper date limit, and Excel counts only matching rows. This guide uses trial signups to show the exact pattern.
Formula Syntax
Use this base syntax for countifs between two dates and replace the ranges with your own spreadsheet columns.
COUNTIFS(date_range, ">="&start_date, date_range, "<="&end_date)Need this formula for your exact sheet?
Generate a custom countifs between two dates formula with your own columns, criteria, and spreadsheet layout.
Step-by-step Example
A trial analytics spreadsheet tracks Trial signup count and needs a formula-driven result instead of manual filtering.
| Signup Date | Plan |
|---|---|
| 2026-04-02 | Free |
| 2026-04-15 | Pro |
| 2026-05-03 | Free |
Resulting formula
=COUNTIFS(A:A,">="&DATE(2026,4,1),A:A,"<="&DATE(2026,4,30))The formula evaluates the Trial signup count rows and returns 2. Replace the sample ranges with your actual columns, then adjust the criteria so the result matches your workbook.
Try It Now
The generator is pre-filled for countifs between two dates. Edit the prompt to match your columns, criteria, and spreadsheet layout.
Generated formula
How it works
Need more formulas every day?
HelpFormula Pro is $7.99/mo for faster spreadsheet work across Excel and Google Sheets.
- ✓ Higher daily formula generation limits
- ✓ Saved formula history for reuse
- ✓ Excel formula language selection
Common Variations
- Count between fixed dates
- Count current month
- Count by date and status
FAQ
How do I set up COUNTIFS between Two Dates for Trial signup count?
Map the sample columns to your own sheet first, then replace the formula ranges with the real ranges from your workbook. Keep text criteria in quotes and verify that date or number columns are stored as real values.
Can this formula handle count between fixed dates?
Yes. Use the same formula pattern and change the criteria, helper column, or lookup value for count between fixed dates. If the logic becomes more complex, generate a custom version with the free tool.
What should I check if the COUNTIFS between Two Dates result is wrong?
Check that every referenced range covers the same rows, locked references use dollar signs where needed, and the criteria type matches the data. For this page, also confirm that the Trial signup count fields are formatted consistently.