To filter dates in Excel, select a cell in your data, choose Data > Filter, open the arrow in the date column, and choose a date filter or specific dates. Excel hides rows that do not meet your selection; it does not delete them. Before starting, make sure the column has a header and Excel recognizes its entries as real dates.
What You’ll Need
- An Excel worksheet with a date column and a header row, such as Order Date.
- A clear idea of which dates you want to see or exclude, such as one month, a date range, or a particular day.
- Microsoft Excel for Microsoft 365 on Windows for the instructions below. On Mac or Excel for the web, the same filtering features are available, though the ribbon layout can differ slightly.
Step-by-Step
- Check and prepare the date column. Each cell should contain one date value, with no title or blank row interrupting the header and records. Dates can display in different formats, such as 3/8/2026 or 8-Mar-2026, and still be valid dates. If you are unsure, select a date cell and look at the Number Format box on the Home tab; a date format is a useful clue, but sorting and filtering are better checks. If your dates are stored as text, see Troubleshooting before applying a date filter.
- Select a cell in the data. Click any populated cell within the list, including a date cell. If the worksheet contains unrelated blocks of data nearby, select the complete range you want to filter instead, including the header row. Avoid selecting only the date column: Excel needs the surrounding fields to keep each record together when it hides rows.
- Turn on the filter controls. On the ribbon, choose Data > Filter. Drop-down arrows should appear beside the column headings. If your data is already an Excel table, filter arrows are usually present automatically; use the arrow in the date heading. You can also turn filtering on with Ctrl+Shift+L in Excel for Windows. On Mac, use Data > Filter if that shortcut differs in your keyboard setup.
- Open the date column menu. Click the arrow beside the date heading. To show or hide individual dates, use the checkboxes in the list: clear Select All, then check the dates you want to keep visible. The list may group dates into years, months, or days. Expand the relevant year or month if needed. Click OK to apply the selection. This is handy for a short list of known dates, but a rule is easier to maintain for long date ranges.
- Choose a date rule for a period. Open the arrow again and point to Date Filters. Choose an option such as Before, After, Between, This Month, Last Month, or Year to Date, depending on the result you need. For a custom period, choose Between and enter the start and end dates in the dialog. For example, to show records from April 1 through April 30, 2026, enter 4/1/2026 as the beginning and 4/30/2026 as the end. Excel treats the endpoints as included in a Between filter. Confirm the dialog to apply it.
- Exclude a specific date or set a more exact condition. In Date Filters, choose Does Not Equal to hide records on one date, or use a suitable custom condition when you need to omit a period. If you need to exclude several non-adjacent dates, use the date checkboxes and clear only the unwanted dates, or apply another filter to a helper column. Be careful: choosing a single date checkbox shows only that date; clearing its checkbox while all other dates remain selected hides that date and keeps the others.
- Check the result and clear the filter when finished. Look at the row numbers and the status bar to confirm that the visible records match your intention. A funnel icon on the heading indicates a filter is active. To remove the condition from just the date column, open its arrow and choose Clear Filter From [column name]. To remove all active filters, choose Data > Clear. To remove the arrows as well, choose Data > Filter again. Clearing a filter makes hidden rows visible; it does not erase or rearrange the original records.
Filters on different columns work together. For instance, filtering Order Date to a month and Status to Shipped shows only rows meeting both conditions. If you want to keep a filtered view for repeated use, save the workbook after applying it; remember that anyone opening the file may see the saved filter state.
Common Mistakes
- Using dates that are actually text. A value that looks like a date can be stored as text, particularly after copying it from a website, CSV file, or another system. Excel may then show Text Filters instead of Date Filters, or treat entries inconsistently. Convert the column to real date values before relying on date rules.
- Filtering the date column without the full records. Sorting or manipulating only one column can separate dates from their associated names, amounts, or order numbers. Apply the filter to the complete table or data range so Excel hides entire rows rather than disrupting the relationship between columns.
- Mixing up display format and stored value. A date displayed as 03/04/2026 may mean March 4 or April 3, depending on regional settings. Changing the display format does not change which date the value represents. Verify ambiguous dates before entering filter boundaries.
- Assuming hidden rows were deleted. Filtering only hides records from view. A visible-row copy, printout, or summary may omit hidden rows, but the original data remains in the worksheet. Clear the filter to show everything again.
- Forgetting other active filters. If dates seem to be missing, another column may still have a filter applied. Check for funnel icons in other headings and use Data > Clear if you want to reset all filter conditions.
Tips
- Use a table for growing lists. Select the data and choose Insert > Table, making sure My table has headers is checked. Tables include filter arrows and typically extend their formatting and filtering behavior when you add new records. They are especially useful for logs that grow over time.
- Use Between for a complete month when the year matters. A month-name filter can include that month across multiple years. If you need April 2026 only, use Between with April 1 and April 30, 2026 rather than selecting April without checking the year.
- Use the date hierarchy to narrow a large list. In the checkbox list, expand a year and then a month instead of scrolling through every individual day. The grouping depends on Excel recognizing the entries as dates; text values may appear as separate ungrouped items.
- Apply multiple conditions deliberately. Filters across separate columns are combined, not treated as alternatives. A date filter for this month plus a region filter for West means this month AND West. Clear a condition you no longer need before interpreting the visible row count.
- Keep an untouched copy of important source data. Filters are reversible, but sorting, pasting, and deleting rows can change the source. Save a copy before making larger cleanup changes, and use a separate worksheet if you need a permanent extract of matching records.
Troubleshooting
The menu shows Text Filters, not Date Filters. Excel may be seeing the entries as text, or the column may contain a mixture of text and dates. Test a few cells by changing their number format to Short Date. If their display does not change and sorting places values unexpectedly, convert them. Select the column and try Data > Text to Columns, then choose the appropriate date order in the final step and finish the conversion. Make a copy first, and verify the results because a wrong day-month order can change the meaning of dates. For imported data, re-importing with the correct regional date setting may be safer.
The date you expect is missing from the checkbox list. First clear the current filter and check for blank rows, misspellings, or entries stored as text. If the list is grouped, expand the correct year and month. Also check whether another column is filtering out the same rows. New records added below a normal range may not be included automatically; convert the range to a table or reapply the filter after extending the data.
Between returns too few or too many rows. Confirm that you entered the full start and end dates with the intended year, and check the regional date order in the dialog. If the date column contains timestamps as well as dates, records on the end date can have times later than midnight and may not behave as expected with a date-only boundary. Consider filtering by calendar date using the grouped date choices or normalizing the source values in a copy of the data before filtering.
The arrows are missing or the filter appears not to work. Click inside the data and choose Data > Filter. Check that the data has one clear header row and no merged cells in the header or range. If the worksheet is protected, filtering may be restricted by its protection settings. Clear existing filters, confirm that your selection includes all records, and try again.
Frequently Asked Questions
Can I filter Excel dates to show only one month?
Yes. Open the date heading arrow, choose Date Filters, and select a month-related rule if it suits your goal. To show a month in one particular year, use Between with the first and last dates of that month.
How do I filter dates between two dates?
Choose the date column arrow, then Date Filters > Between. Enter the beginning and ending dates and confirm. Check the year and regional date order, especially if your worksheet uses day/month/year formatting.
How do I exclude one date but keep the rest?
In the date checkbox list, clear Select All and select the dates to keep, or select all and clear only the date to exclude. For one exact date, Date Filters > Does Not Equal can be more direct.
Will filtering dates delete the other rows?
No. Filtering hides rows that do not match the selected dates. Choose Data > Clear or clear the filter from the date heading to display them again. Avoid deleting rows unless you intend to remove records permanently.
Can I filter dates in Excel for Mac or the web?
Yes. Excel for Mac and Excel for the web offer column filter menus and date-filter options. The ribbon placement or dialog appearance can vary slightly, so look for the filter arrow on the date heading and the Date Filters menu.
Why does Excel sort my dates incorrectly?
Some entries may be text rather than date values, or the data may contain mixed formats. Convert the affected values to genuine dates, check the regional date order, and then sort or filter again. Do not assume that changing the cell’s visual format alone converts text into dates.
Related
- How to Do Superscript in Excel with a Shortcut
- How to Format Subscript Numbers in Microsoft Excel
- Quick Average in Excel: A Fast Way to Find the Mean
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Yes or No Formula: How to Return Either AnswerYes. To show “Yes” when a test is true and “No” when it is false, put the value…
- How to Capitalize Words in Excel: Shortcuts and FormulasExcel has no built-in keyboard shortcut that directly changes the case of selected text. To capitalize the first…
- Excel Formula Bot Free? Free Plans, Limits, and Safe UseYes—many Excel formula bots offer free access, but it is usually limited by usage, features, or account requirements.…
- COUNTA and COUNTIF in Excel: How to Use Them TogetherTo find what share of filled status cells say Complete, with statuses in B2:B11, use =COUNTIF(B2:B11,"Complete")/COUNTA(B2:B11). If five…
- Excel Formula to Extract the First Five Digits from D2Assuming D2 contains the text or number you want to search, use =IFERROR(IF(D2="","",LEFT(TEXTJOIN("",TRUE,IFERROR(MID(D2,SEQUENCE(LEN(D2)),1)*1,"")),5)),"") to collect the first five…
- VLOOKUP Between Two Excel Workbooks: A Simple GuideYes. In Excel for Microsoft 365 on Windows, VLOOKUP can search a table in another workbook by using…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.