Excel Date Filter Multiple Criteria: Practical Methods

Formulas & functions · Updated November 19, 2026

To filter dates in Excel by multiple criteria, turn on AutoFilter, open the date column’s dropdown, and choose Date Filters > Between for a range; use the filter’s AND/OR options when you need two conditions. For more complex rules—such as matching either of two separate date ranges—use Advanced Filter or a formula with FILTER.

What “multiple criteria” means in an Excel date filter

Multiple criteria can mean several different things. You might want dates within a start and end date, records from selected months, dates meeting conditions in more than one column, or dates from either of two separate periods. The right approach depends on whether the conditions must all be true or whether any one of them is enough.

For example, “on or after January 1 and on or before January 31” is an AND condition: both rules must be met. “In January or March” is an OR condition: a row qualifies if it meets either date range. Excel’s standard filter handles many straightforward cases, but OR across multiple ranges can require a different method.

Excel stores valid dates as serial numbers, so date filters work on date values rather than how they look on screen. A cell displaying 1/5/2026 might contain a real date, while a cell containing text that looks like 1/5/2026 may not. That distinction explains many filters that appear to miss matching rows.

Use AutoFilter for a date range

For a basic date range, AutoFilter is usually the quickest option. Make sure the data has a single header row and that the date column contains dates consistently. On Excel for Microsoft 365 for Windows, select a cell in the data and choose Data > Filter. You can also use Home > Sort & Filter > Filter. A dropdown arrow appears in each header.

  1. Open the dropdown in the date column.
  2. Point to Date Filters, then choose Between. If your version shows a different menu, choose the equivalent custom date condition.
  3. Enter the beginning and ending dates, and confirm the filter.
  4. Check the remaining rows and, if needed, open the dropdown again to adjust or clear the conditions.

The date filter applies to the date column while AutoFilter hides rows that do not meet the condition. Filters on different columns combine as AND: for example, filtering the date to January and the region to West shows only rows that match both. The rows are hidden, not deleted, so clearing the filter restores them.

On Excel for Mac, the filter is also available from the Data tab, though menu placement and appearance can vary by release. Excel for the web provides column filters too, but some advanced data-management options are easier to access in the desktop app.

Combine conditions with AND or OR

In a custom filter, AND means a row must satisfy both conditions; OR means satisfying either condition is enough. For a date range, choose AND—for example, a date greater than or equal to January 1 and less than or equal to January 31. That describes one continuous period.

OR is useful when the dates are not one continuous period. For instance, a rule for dates in January or March includes both months but excludes February. A custom filter generally offers two conditions for one column, which is useful for a pair of boundaries or a simple two-part rule. It is not a convenient way to build a long list of unrelated ranges.

For multiple selected months, the date dropdown may show dates in a year-and-month hierarchy. Expand the relevant years and check the months or dates you want. Pay attention to the year: selecting January under two different years includes both Januaries. If the year matters, select the specific year and month rather than relying on the month name alone.

Account for times in date cells

A date that looks like January 31 may actually include a time, such as January 31 at 4:30 p.m. Excel stores the time as a fraction of a day. Consequently, a test that treats the end date as exactly midnight at the start of January 31 can exclude later times on that date.

AutoFilter’s Between date option is often adequate for routine filtering, but the underlying time values are worth checking if rows at the end of a period disappear. For formula-based filtering, a reliable pattern for including every time on the ending date is to require a date-time to be earlier than the day after that date. The example in the formula section uses this approach.

To inspect a suspicious value, temporarily apply a date-and-time number format or widen the column. You can also select the cell and look at the formula bar. Formatting changes how a value appears; it does not remove a time stored in the cell.

Filter noncontiguous date periods with Advanced Filter

Advanced Filter can express more involved criteria, including OR conditions that standard AutoFilter’s two-condition dialog does not handle conveniently. On Windows, choose Data > Advanced in the Sort & Filter group. You can filter the list in place or copy matching rows to another location. The list range should include its header, and the criteria range needs headers that match the field being filtered.

In an Advanced Filter criteria range, conditions on the same row are combined as AND; conditions on separate rows are combined as OR. To describe two date ranges, use separate criteria rows for the alternatives. A range itself needs a lower and upper boundary, which can be represented with two columns carrying the same date-field header. This arrangement is powerful but less intuitive than selecting dates in the AutoFilter checklist.

Advanced Filter criteria can be sensitive to how dates are entered and to the computer’s regional date settings. Use unambiguous, genuine date values and verify that Excel recognizes the criteria. Keep the source data’s header text consistent with the criteria headers. If the setup will be reused often, test it on a copy or a small sample before applying it to a large list.

Use FILTER for a live, formula-based result

When you want matching rows displayed elsewhere and updated as the date boundaries change, the FILTER function is a practical alternative. FILTER is available in Microsoft 365 and Excel 2021 or later. It returns a dynamic array, so the cells below and to the right of the formula need to be clear for the results to spill.

Assume dates and times are in A2:A5, activities are in B2:B5, the start date is in E1, and the end date is in F1. The entries are January 3 at 9:00 a.m. (Site visit), January 7 (Draft), January 10 at 4:00 p.m. (Review), and January 11 (Send), all in 2026; E1 is January 1, 2026, and F1 is January 10, 2026. Enter this formula in an empty cell:

=FILTER(A2:B5,(A2:A5>=E1)*(A2:A5<F1+1),"No matches")

The multiplication combines the two tests as AND: a row must be on or after E1 and before the day after F1. The result is three rows—Site visit, Draft, and Review. The January 10 entry is included despite its afternoon time, while January 11 is excluded. If no rows meet the conditions, the formula returns “No matches.”

To show either of two separate date ranges with FILTER, the inclusion tests can instead be combined with addition, which acts like OR for TRUE/FALSE tests. Be careful with the ranges and parentheses: a broad OR condition can include more rows than intended. For a simple one-off task, AutoFilter may be clearer; a formula is useful when the output needs to remain visible beside the source data or respond to changed boundary cells.

Common problems and how to fix them

  • Dates are stored as text. If the column contains text, Excel may sort or filter it differently from real dates. Convert the values to dates before relying on date filters, and check that they are recognized as dates rather than merely formatted to look like dates.
  • The filter range misses rows. A blank row or a separate block of data can cause Excel to treat the list as multiple regions. Use a consistent, contiguous table with headers, or select the intended range before filtering.
  • The year is wrong or missing. A displayed month or day may hide the year. Expand the date hierarchy or use a format that includes the year while checking results.
  • End-of-day rows are excluded. Look for time values in the date column. A date-only condition may not behave as expected if the stored value includes a time; an exclusive next-day boundary in a formula handles this case.
  • Old results remain after changing criteria. Reopen the column dropdown and choose the desired filter or clear the filter. If using FILTER, check that the result area is not blocked by existing cell contents.

Also remember that the filter arrow’s checkbox list and the Date Filters menu serve different purposes. Checkboxes are convenient for selecting specific visible items; Date Filters is better for rules such as before, after, or between dates. Neither option changes the underlying date values.

Choose the method that fits the task

Use AutoFilter for quick, interactive filtering of a list; it is usually the clearest choice for a single range, a month, or a small set of selected dates. Use Advanced Filter when you need a reusable criteria layout or more elaborate OR logic. Use FILTER when you want a separate, formula-driven result that updates as its inputs change.

For recurring work, format the source as an Excel table using Insert > Table. Tables make headers and data ranges easier to manage as records are added, although they do not change the logic of date criteria. Whichever method you choose, first confirm that dates are real date values and decide explicitly whether the rule is AND or OR.

Frequently Asked Questions

Can Excel filter dates between two dates?
Yes. Open the date column’s filter dropdown, choose Date Filters > Between, enter the start and end dates, and apply the filter. If the cells include times, check that records late on the ending date are included.

How do I filter for January or March, but not February?
For a short selection, use the date dropdown’s year-and-month checklist and select January and March under the correct year. For more complex or repeated OR rules, use Advanced Filter or a FILTER formula.

Can I filter dates and another column at the same time?
Yes. Apply a date filter and then filter the other column, such as Status or Region. Excel combines filters across columns as AND, so visible rows must satisfy both column filters.

Why does Excel not recognize my dates?
The entries may be text rather than date values, or their format may not match the computer’s regional settings. Check a sample cell and convert the column to actual dates before applying date-specific filters.

Does filtering delete rows?
No. AutoFilter hides rows that do not match; it does not delete them. Clear the filter to show the full list again. Take care when copying or editing filtered data, since only visible rows may be selected in some operations.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.