How to Filter Dates in Excel: A Step-by-Step Guide

Formulas & functions · Updated November 20, 2026

To filter dates in Excel, select a cell in your data, choose Data > Filter, open the dropdown in the date column, then choose a date option under Date Filters or select the dates you want. Your data must have a header row, and the values in the date column need to be recognized by Excel as dates—not just text that looks like dates.

What You’ll Need

  • An Excel worksheet with a row of column headings and one date column.
  • A continuous block of data, with no completely blank rows or columns splitting the records.
  • Dates stored as Excel date values. A consistent display format, such as 3/14/2026 or 14-Mar-2026, makes them easier to check, but changing how a value looks does not turn text into a real date.

The steps below are for Excel for Microsoft 365 on Windows. On Mac and Excel for the web, the ribbon and dropdown may look a little different, but the basic process—turn on filtering and use the date column’s dropdown—is similar.

Step-by-Step

  1. Check the layout and identify the date field. Look for one clear header row, such as Order Date, and make sure each row below it represents one record. Avoid merged cells in the data area. If the date column contains a mixture of dates, text, and blanks, filtering may not behave consistently. If you are unsure whether a value is a true date, select a cell and temporarily choose Home > Number Format and set it to General. A real Excel date usually displays as a number; set it back to a date format afterward. Do not overwrite the value while checking.
  2. Turn on the filter arrows. Click any cell inside the data block; you do not need to select the entire worksheet. Choose Data > Filter. Excel adds a dropdown arrow to each header. If Excel identifies the range incorrectly, undo or turn filtering off, select the full range including the headings, and choose Data > Filter again. You can also make the range an Excel table with Insert > Table, confirm the range, and check My table has headers. Tables include filter arrows by default and are useful for data that grows over time.
  3. Open the date column’s dropdown. Click the arrow beside the date heading—not an arrow beside a different field. The menu normally shows a search box, a list of available date values, and a Date Filters option. If Excel displays Text Filters instead, or the values appear as individual text entries rather than a date hierarchy, Excel may be treating the column as text. Resolve that before relying on date-based conditions.
  4. Choose the type of date filter you need. For a quick selection, expand the date hierarchy and check the year, month, or individual days to show. Clear Select All first if you want only a small group of dates, then check the dates to keep. For a rule-based filter, point to or select Date Filters and choose a condition such as Before, After, Between, or a calendar period such as This Month, where available. The exact menu choices can depend on the date values and Excel interface.
  5. Enter the date or range boundaries. For a condition like Between, enter the start and end dates in the filter dialog, then confirm with OK. For example, a range from April 1 through April 30 will show records within those boundaries. Use dates Excel recognizes; if typing 4/1/2026 produces an unexpected result, try a less ambiguous entry such as 1-Apr-2026 or choose a date from the calendar control. Check whether the condition uses inclusive or exclusive wording in the dialog, especially when choosing greater-than or less-than rules.
  6. Review the visible rows. Excel hides records that do not meet the filter; it does not delete them. Look for the filter indicator in the date heading and confirm that the visible dates match your goal. If you also filter another column—for example, Region—Excel applies both filters, so only rows satisfying both conditions remain visible. A smaller-than-expected result may therefore be caused by another active filter rather than the date condition itself.
  7. Change or remove the filter when finished. Reopen the date dropdown to adjust the selection. To clear only that column’s condition, choose Clear Filter From followed by the column name. To remove all active filters while keeping the dropdown arrows, use Data > Sort & Filter > Clear. To turn the arrows off, choose Data > Filter again. On Windows, Ctrl+Shift+L toggles filters for a selected data range; in Excel for Mac, the commonly used equivalent is Command+Shift+F. Shortcuts may vary with keyboard settings.

For records that include both a date and a time, take extra care with boundary conditions. A date-time value is stored with a time component, so a condition ending at midnight on the final day can omit later times on that day. If the dropdown’s standard date option does not include every record you expect, use a custom filter that starts at the beginning of the first day and stops before the beginning of the following day. Alternatively, filter by the date hierarchy if it correctly groups the timestamps by calendar day.

Common Mistakes

  • Filtering text that only looks like a date. Values pasted from a website or imported from a system may be text. Applying a date format changes appearance, not the underlying value, so the date filter may offer text options or sort the values unexpectedly.
  • Selecting dates without clearing Select All. If every date remains checked, clicking one additional date does not necessarily limit the results. Clear the existing selection first, then mark the dates to keep.
  • Applying the filter to only part of the records. A blank row or an accidental partial selection can make Excel detect an incomplete range. Some records may then appear unaffected because they are outside the filtered block.
  • Assuming hidden rows are deleted. Filtering hides nonmatching records from view. They are still in the workbook and will reappear when the filter is cleared.
  • Forgetting other active filters. Filters in different columns work together. A date range can be correct while a separate status or category filter hides additional rows.
  • Entering an ambiguous date. A value like 04/05/2026 can mean April 5 or May 4 depending on regional settings. Confirm the displayed date and use a month name when clarity matters.

Tips

  • Use a table for recurring work. With the data converted using Insert > Table, new records added directly beneath the table are generally included as it expands. Keep the date heading descriptive, and avoid putting notes or totals inside the record area.
  • Choose the quickest filter for the question. Selecting a few specific days is convenient for a short list. Use Between for a defined reporting window, and options such as This Month for a period that should follow the calendar as time passes.
  • Format dates consistently before sharing. Select the date cells and choose a clear display from Home > Number Format. Consistent formatting helps people spot incorrect entries, but remember that formatting alone will not convert text to dates.
  • Keep a copy of the original imported data. If you need to convert or clean a column, duplicate the worksheet or save a copy first. This gives you a way to compare the source values if a conversion produces unexpected dates.
  • Check the filter indicator. A filtered column shows a filter icon in its heading, making it easier to notice that the worksheet is still restricted. Clear filters before drawing conclusions from a total or copying visible results.

Troubleshooting

The menu shows Text Filters instead of Date Filters. Excel probably sees at least some entries as text, or the selected column is not recognized as a date field. Check a few cells using General number format and compare how the values align and sort. If you imported the column, use Excel’s data-conversion tools or correct the source format, then apply the filter again. A date display format alone will not fix text values.

Some dates are missing from the dropdown. Check for extra spaces, blank cells, text dates, or values outside the filtered range. Also verify that another column is not filtered. If records were added after the filter was set, confirm that they are inside the table or filtered range. Turning the filter off and back on after selecting the full range can help Excel recognize the complete dataset.

The results include the wrong day or month. Regional date settings may interpret numeric dates differently. Select an affected cell and check its underlying value and display format. Re-enter the value unambiguously, such as 14-Mar-2026, if the intended date is March 14. If dates came from a CSV or an external system, revisit the import settings or clean the source column rather than relying on a display-format change.

Records from the end date are missing. Look at whether the column includes times as well as dates and inspect the condition in the filter dialog. For a timestamp range, make the upper boundary the start of the day after the final day and use a less-than condition, so all times on the final date are included. If the menu does not offer the needed comparison, check whether a custom date filter is available for that column.

The dropdown arrows disappeared or filtering seems unavailable. Click within the data and choose Data > Filter to turn the arrows back on. If the sheet is protected, filtering may be restricted by its protection settings; ask the workbook owner or adjust protection permissions if authorized. In Excel for the web or Mac, look for the Filter command on the Data tab if the Windows ribbon layout is different.

Frequently Asked Questions

Can I filter Excel dates by month or year?
Yes. Open the date column dropdown and use the date hierarchy to select a year, month, or specific dates. You can also use a calendar-period option under Date Filters when it is available.

How do I show dates between two days?
Open the date dropdown, choose Date Filters > Between, enter the two boundaries, and confirm. Review the dialog’s comparison wording. If your cells include times, use a boundary that includes the whole final day.

Can I filter dates in one column and another field at the same time?
Yes. Apply a filter to each relevant column. Excel displays rows that meet all active column conditions, so clear other filters if the combined result is narrower than expected.

Will filtering remove or change my data?
No. A filter hides rows that do not match; it does not delete or edit them. Clear the filter to show the full list again. Be careful when copying or totaling results, since hidden rows may not be visible on screen.

Why does Excel sort or filter my dates incorrectly?
The cells may contain text, mixed date formats, or dates interpreted under different regional settings. Confirm that Excel recognizes the values as dates, convert inconsistent entries, and then reapply the filter.

Do the steps work in Excel for Mac and Excel for the web?
The core dropdown filtering process is similar, though ribbon placement, shortcuts, and available menu options can differ. On Mac or the web, use the Data tab’s Filter command and inspect the date column dropdown for the equivalent date conditions.

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.