How to Filter Multiple Dates in Excel by Range or List

Formulas & functions · Updated November 20, 2026

To filter multiple dates in Excel, turn on the column filters, open the arrow on your date column, and either select the individual dates you want or choose Date Filters > Between for a continuous range. The date column must contain real Excel dates—not text that only looks like dates—for the date-specific options to work reliably.

What You’ll Need

  • A worksheet with one header row and a date column, such as Order Date or Due Date.
  • Dates stored as Excel date values. If you are unsure, format a sample cell as General; a number usually indicates a stored date, while unchanged date-like text may need converting.
  • For the optional helper-column method below, a short list of the dates you want to keep.

Step-by-Step

  1. Check the data layout. Make sure each column has a unique header and there are no completely blank rows splitting the data. Each record should occupy one row, with its date in the same date column. If you are working with a formatted Excel Table, its header filters may already be visible; you do not need to turn on a second set.
  2. Select the data and turn on filters. Click a cell inside the data range. On Windows, press Ctrl+Shift+L, or use Data > Filter. Excel adds a drop-down arrow to each header. If Excel does not identify the full range, select the entire dataset, including the headers, before choosing Filter. On Mac or Excel for the web, use Data > Filter if the Windows shortcut is unavailable or differs in your setup.
  3. Open the date-column menu. Click the arrow in the date column’s header. The menu usually shows a checklist of dates as well as a Date Filters option. If you see Text Filters instead, Excel may be treating the entries as text; see Troubleshooting before proceeding.
  4. Choose separate exact dates from the checklist. Clear (Select All), then tick each date you want included. Scroll within the list if necessary, and expand a year or month if Excel displays dates in a hierarchy. Click OK. Excel keeps rows matching any of the checked dates, so this is the simplest choice for, for example, the 3rd, 8th, and 12th of a month when you do not want the dates between them.
  5. Filter a continuous date range. Open the same date-column arrow and choose Date Filters > Between. Enter the start and end dates in the two boxes, then confirm. This keeps dates from the first date through the last date, including both endpoints. Use this for a period such as a week, month, or reporting window rather than selecting every date one by one.
  6. Use a helper column for a long or reusable date list. This is handy when you have many target dates, need to repeat the same filter, or cannot conveniently find every date in the menu. Put the dates to keep in D2:D10, and add a header such as Keep? in E1. With source dates in A2:A1000 and the target dates in D2:D10, enter =COUNTIF($D$2:$D$10,A2)>0 in E2, then fill it down alongside the records. Filter the Keep? column to show TRUE. For example, if D2:D4 contain April 3, April 8, and April 12, a row dated April 8 returns TRUE; a row dated April 9 returns FALSE. The formula checks whether each row’s date appears in the target list.
  7. Check the filtered results. Look for the filter symbol on the date-column arrow and confirm that the visible rows match the dates you intended. Remember that filtering hides nonmatching rows; it does not delete them. Clear or change the filter when you want to see the full dataset again.
  8. Save or share the workbook if needed. The filter settings are generally saved with the workbook, but recipients may see a filtered view when they open it. If you want to leave the full list visible, clear the filters before saving.

Common Mistakes

Choosing a range when you mean separate dates. Between includes every date in the interval. If you only want a few nonconsecutive dates, select those values in the checklist or use a helper column; a range would also show the unwanted days between them.

Leaving Select All checked. If all dates remain selected, changing one checkbox may not produce the intended selection. Clear the selection first, choose the dates to include, and then apply the filter.

Filtering only part of the dataset. If blank rows or columns divide the records, Excel may apply the filter to just one block. Remove unintended blank rows or select the complete range, including every relevant column, before turning on Filter.

Assuming dates that look alike are stored alike. A true date, text such as “Apr 8,” and a timestamp on Apr 8 can behave differently. Check the underlying values and whether times are present before concluding that a date has disappeared.

Tips

  • Use an Excel Table for an expanding dataset: select the range and choose Insert > Table. Tables include header filters and typically extend them to new rows.
  • To remove just one filter, open that column’s menu and choose Clear Filter From the column. To clear all filters, use Data > Sort & Filter > Clear where available, or toggle Filter off and back on if you need to reset the displayed filter state.
  • If the list is long, sort the date column oldest to newest first or use the menu’s search box if your Excel version shows one. Sorting changes row order, not the underlying dates.
  • For records that include both a date and a time, decide whether the time matters. A filter checklist may distinguish separate timestamps even when they fall on the same calendar day. A helper formula can compare just the date portion. With date-time values in A2:A1000 and midnight dates in D2:D10, use =COUNTIF($D$2:$D$10,INT(A2))>0 in E2 and fill down. INT removes the time fraction for the comparison; the target list must contain valid dates.
  • When checking a filtered total, remember that ordinary calculations may still include hidden rows. Use a subtotal designed to respond to filtered-out rows if you need a visible-rows-only total.

Troubleshooting

The menu says Text Filters, not Date Filters: The cells may contain text. Try selecting the column and choosing Data > Text to Columns, then continue through the wizard and select a date format that matches the data before finishing. Make a copy first if the column contains mixed formats. Another option is to convert the text using a suitable date formula or re-enter the values as dates, then apply the filter again.

A date you expect is missing from the checklist: Check for leading or trailing spaces in text dates, hidden rows, and entries outside the range covered by the filter. Clear existing filters and confirm the date is present in the source data. If the date was added after filtering, turn the filter off and on again or expand the Table/range.

The filter shows no rows: Confirm that the selected date and the source values match exactly, including year. If the source contains times, a value such as April 8 at 2:00 p.m. may not equal a target date stored as midnight; use the INT helper formula above or normalize the source values.

Some rows do not filter with the rest: Look for blank rows, merged cells, or records outside the selected range. Unmerge cells in the data area where possible, remove separating blank rows, then select the full dataset and reapply Filter. Keep one consistent header row.

The checklist selection seems to reset: Open the menu again and verify the checked values. If the date hierarchy is collapsed, expand the relevant year or month; selecting a parent group can include more dates than intended. Apply the filter after checking the individual dates you need.

Frequently Asked Questions

Can I filter for several nonconsecutive dates at once?
Yes. Open the date-column arrow, clear Select All, check each required date, and click OK. For a long list, a helper column with a target-date list is easier to maintain.

Can I filter dates from more than one month or year?
Yes. Select the required dates in the checklist, expanding the relevant month or year groups as needed. You can select dates across different months and years in the same filter.

Does Date Filters > Between include the start and end dates?
Yes. Between is intended to include both boundary dates. Check that the entries use the correct year and are genuine dates if the results do not match your expectations.

Can I filter by a month without choosing every date?
Usually. Open the date filter and select the relevant month group if Excel shows a year-and-month hierarchy. You can also use Date Filters options such as All Dates in the Period when that option is available.

Will filtering delete the other dates?
No. Filtering hides rows that do not meet the criteria. Clear the filter to display them again; do not delete hidden rows unless you intend to remove that data.

Do these steps work in Excel for Mac and the web?
The filter checklist and date-filtering approach are also available in current Excel for Mac and Excel for the web, though menus and shortcuts can differ. If a shortcut does not work, use Data > Filter and the date-column arrow.

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.