To filter dates in Excel, select a cell in your data, choose Data > Filter, open the arrow in the date column, and choose dates from the list or use Date Filters for a month, year, or date range. Filtering hides rows that do not match; it does not delete them. Before you start, check that the column contains real Excel dates and has a clear header.
What You’ll Need
- A worksheet with dates in one column and a header in the top row of the data, such as Order Date.
- A consistent column of actual Excel dates. Dates may display in different formats, but Excel must recognize their underlying values as dates.
- If the list is part of a larger table, a cell selected inside the table. Excel can then apply the filter to the connected data range.
The steps below are for Excel for Microsoft 365 on Windows. Excel for Mac and Excel for the web have similar filtering tools, though some menu layouts and date-picker details can differ.
Step-by-Step
- Check the layout. Make sure the first row of your data has a distinct heading for the date column, and avoid blank rows or blank columns inside the dataset. Each row should represent one record, with its date in the same date column. If your data has several header rows, select the actual data range and make sure the filter will use the correct header row.
- Select a cell in the data. Click any cell in the dataset, preferably below the header and within the rows you want to filter. If the data is already an Excel table, clicking a cell inside it is enough. For an ordinary range, Excel usually detects the connected block of data; if it does not, select the full range including its header before turning on filters.
- Turn on the filter arrows. On the ribbon, choose Data > Filter. A dropdown arrow should appear in each header cell. You can also use the Windows shortcut Ctrl+Shift+L to toggle filters on or off. On a Mac, use Command+Shift+F if that shortcut is available in your Excel setup; otherwise use Data > Filter. If the arrows appear in the wrong row, turn filtering off and select the intended range with the correct header row.
- Open the date column menu. Click the arrow beside the date heading, not the arrow in a different column. If Excel recognizes the values as dates, the menu normally includes a Date Filters option and a checklist that may group dates by year, month, or day. Depending on the data and the available space, you may need to scroll within the menu to see all its choices.
- Show selected dates using the checklist. To show only chosen date entries, clear Select All, then select the dates or groups you want to keep visible. For example, expand a year and select one or more months to show only those months. Click OK to apply. When the checklist groups dates into a hierarchy, use the small expand or collapse controls beside a year or month to reveal its lower-level entries. The exact grouping shown depends on the dates in the column.
- Filter for a whole month or year. Open the date heading menu and look for Date Filters > All Dates in the Period, then choose an available period such as a month or quarter. If you want a particular year, use the checklist to select that year, or use a date range covering the year. Menu options can vary with the values in the column; choosing a year in the checklist is often the most direct method when years are grouped there.
- Set a date range. Open the date heading menu and choose Date Filters > Between. Enter the beginning and ending dates in the two criteria boxes, then confirm the filter. For example, a range from January 1 through March 31 shows dates on those boundary dates as well as dates between them. Enter dates in a format Excel recognizes in your regional settings. If the dialog offers a date picker, you can use it instead of typing.
- Show dates before or after a cutoff. Choose Date Filters and select an option such as Before or After, then provide the cutoff date. Use On or Before or On or After when the cutoff date itself should be included. Check the option wording carefully: Before and After typically exclude the cutoff, while the inclusive options include it.
- Exclude a date or group of dates. If the checklist is available, clear Select All, select the dates to keep, and leave the dates you want to hide unchecked. For a single date, another option may be available under Date Filters > Custom Filter: choose a does-not-equal condition and enter that date. To exclude a whole interval while keeping dates on both sides, a custom filter can use two conditions joined with Or—dates before the interval or dates after it. Confirm the criteria carefully so you do not accidentally hide all rows in the interval’s surrounding dates.
- Review and remove the filter when finished. Look for the filter symbol in the date heading and scan the visible rows to confirm they match your intention. To remove only this column’s condition, open its dropdown and choose Clear Filter From followed by the column name. To clear filters across the data, use Data > Sort & Filter > Clear. Clearing a filter reveals the hidden rows; turning off Filter removes the dropdown arrows as well.
When a filter is active, Excel hides entire rows that fail the condition. Other columns in those same rows are hidden too, so a filtered result still preserves the original records rather than rearranging date values independently. If you need a separate, continuously updating list of matching records rather than temporarily hiding rows, that is a different task from using the column filter.
Common Mistakes
Assuming dates that look alike are stored alike. A cell can display something like 3/4/2025 but contain text rather than a date value. In that case, Excel may offer text filters instead of date filters, or sort the entries in an unexpected order. Appearance alone does not prove Excel recognizes the value as a date.
Selecting the wrong header or range. If a title row is included above the real column headings, Excel may treat it as the header. If an empty row splits the dataset, the filter may apply to only part of it. Check that the dropdown is beside the intended date heading and that every relevant record is inside the filtered range.
Confusing hiding with deleting. A filter does not erase records, but copying only visible cells or deleting rows while a filter is active can have consequences. If you only want to inspect a subset, use the filter and avoid deleting anything. Keep a backup before making bulk changes to filtered data.
Using the wrong boundary logic. A Between filter includes the dates entered at its boundaries in typical Excel date filtering. Before and After are different from On or Before and On or After. If the first or last day matters, check the option names and verify the visible results.
Tips
Format the column consistently for easier reading. Select the date cells, then use Home > Number Format to pick a date display such as Short Date. Changing the display format does not usually change the underlying date; it makes the values easier to interpret. For example, a consistent month/day/year or day/month/year display can help prevent confusion when reviewing a range.
If you filter often, convert the data range to an Excel table with Home > Format as Table and confirm that the table has headers. Tables include filter arrows and generally extend to include new rows added directly below them. This can make recurring date filtering easier, though you should still verify that newly added data is part of the table.
Use an explicit start and end date for a fixed reporting period rather than relying on a relative filter such as This Month. Relative choices are useful for current-period views, but their results change as time passes. A fixed range is easier to reproduce later, such as when preparing a report for a completed month or quarter.
After applying more than one column filter, remember that the conditions work together: a row must meet the active conditions to remain visible. If a date filter seems to return too few records, check the other column headings for active filter icons. You can clear filters one at a time to identify which condition is restricting the results.
For large lists, sort and filter can complement each other. Sorting the date column from oldest to newest helps you inspect the earliest visible records, while filtering limits which records appear. Sorting changes row order but does not remove entries; filtering hides nonmatching rows until cleared.
Troubleshooting
The menu shows Text Filters, not Date Filters. Excel may be treating some or all entries as text. Check a few cells by changing their number format or examining whether they behave like dates when sorted. If dates were imported as text, select the affected column and use Data > Text to Columns. In the wizard, choose Delimited, click Next twice, select the appropriate date order under Column data format (for example, MDY or DMY), and click Finish. This can convert recognizable text dates; make a copy first if the source values are important, and verify the results because the correct order depends on how the dates were written.
The date range misses entries that should match. Confirm that the start and end dates were entered in a format Excel interprets correctly for your computer’s regional settings. Check whether an entry includes a time as well as a date; a value with a time later than midnight can affect comparisons at a boundary. If needed, choose a wider range and inspect the records near its edges, or standardize the source data before applying the filter.
Some dates are absent from the checklist. The checklist may be showing only values currently available after another column’s filter has been applied. Clear other filters temporarily and reopen the date menu. Also check for blank cells, spelling variations, and text-formatted dates, which may appear in a separate group or behave differently from valid dates.
The filter arrow or expected rows are missing. Look for merged cells, blank rows, or multiple separate blocks of data. Excel filters work best with one header row and a continuous rectangular range. Turn off the filter, select the complete range explicitly, and choose Data > Filter again. If the workbook is protected, you may also need permission to change its filter settings.
The results seem to change unexpectedly. Check for a relative date filter, another active column filter, or new rows added to the source. Relative criteria such as a current month move forward over time. For a report that must always show the same dates, replace the relative selection with fixed start and end dates.
Frequently Asked Questions
Can I filter an Excel date column to show only one month?
Yes. Open the date column dropdown and use the grouped checklist to select the year and month you want, or choose the month from Date Filters > All Dates in the Period if that option is available. If the same month occurs in multiple years, include the correct year so Excel does not show dates from other years too.
Does filtering dates delete the other rows?
No. A filter hides rows that do not meet the criteria; it does not delete their data. Use the column’s clear-filter option to show those rows again. Be cautious when deleting or copying while filtered, because only visible rows may be involved in some actions.
How do I filter out one specific date?
Open the date checklist, clear Select All, and select every date you want to keep while leaving the unwanted date unchecked. If your menu provides a custom date filter, choose a does-not-equal condition for the date you want to exclude.
Can I filter dates in Excel for Mac or Excel for the web?
Yes. Both provide column filters and date criteria, although the menus and shortcuts may differ from Excel for Windows. On Mac or in the web app, use the ribbon’s Data tab and the dropdown in the date heading if a Windows-specific shortcut or menu arrangement is not available.
Why does Excel treat my dates as text?
This commonly happens after importing data or when dates use a different regional order than Excel expects. Convert the values using Data > Text to Columns with the correct date order, then check a few converted cells and reopen the filter menu. If conversion does not work, inspect the source for inconsistent separators or extra spaces.
Related
- Forecast Sheet in Excel: Enable It and Build a Forecast
- Distinct Count in Excel PivotTables: How to Enable It
- How to Enable AutoSave in Excel for Automatic Saving
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel INDEX MATCH Tutorial: Exact and Flexible LookupsTo look up a value with INDEX MATCH in Excel, use MATCH to find the position of a…
- Excel VLOOKUP Yes or No: How to Return a Match ResultYes. In Excel for Microsoft 365, you can make VLOOKUP return “Yes” or “No” by wrapping an exact-match…
- Excel Roundup a Sum: 10 Useful Formula PatternsTo round an Excel total up to the next whole number, put the amounts in B2:B5 and enter…
- Excel SUBTOTAL with FILTER: How to Sum Visible RowsTo total values that remain visible after applying Excel’s built-in column filter, use SUBTOTAL on the original data…
- VLOOKUP Between Two Sheets in Excel: A Practical GuideTo look up a value from one Excel sheet on another, enter a VLOOKUP formula such as =VLOOKUP(A2,Products!$A$2:$C$100,3,FALSE).…
- Excel SEQUENCE: Create Automatic Number SequencesYes. In Microsoft Excel for Microsoft 365, enter a SEQUENCE formula to generate a series automatically: with an…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.