Formula example
FILTER Rows by Date
You want to return all sales rows where the Date column is on or after the date in F1.
Copyable formula
=IFERROR(FILTER(A2:D100, A2:A100>=F1), "No matches")Sample data
| Date | Region | Product | Amount |
|---|---|---|---|
| 2026-01-04 | East | Widget | 420 |
| 2026-01-12 | West | Widget | 310 |
| 2026-02-03 | East | Gadget | 275 |
| 2026-02-15 | East | Widget | 640 |
Formula explanation
- A2:D100 is the range returned by FILTER.
- A2:A100>=F1 keeps only rows on or after the date in F1.
- IFERROR returns a friendly message instead of a raw no-match error.
Common errors
- The date cell must contain a real date value.
- FILTER output needs empty spill space below and to the right.
- For multiple conditions, use the builder to generate the correct Excel or Sheets syntax.
Build your own version
Use the deterministic builder for this pattern: FILTER Formula Builder.
Related formulas
FAQ
Does FILTER work in older Excel?
FILTER requires dynamic array Excel. Older versions need helper columns or Advanced Filter.
Can I filter before a date too?
Yes. Change >= to <, <=, or another comparison operator.