To filter specific dates in Excel, select a cell in your data, choose Data > Filter, open the arrow in the date column, then use Date Filters for one date or a range, or select dates from the checklist. Your date column must contain real Excel dates, not text that only looks like dates. The steps below are for Excel for Microsoft 365 on Windows.
What You’ll Need
- A worksheet with a single header row and a column containing the dates you want to filter.
- Date entries stored as Excel dates. Excel may display them as 3/15/2026 or March 15, 2026, but the underlying values need to be dates rather than text.
- A saved copy of the workbook if you plan to change or convert date data while troubleshooting.
You do not need a formula for the standard filter. If the worksheet already uses an Excel table, its header row will usually have filter arrows; you can use those instead of turning on a separate filter.
Step-by-Step
- Check the layout. Make sure each column has one clear heading, such as Order Date, and that the records sit directly below the headings. Remove completely blank rows or columns inside the data range if possible. A blank row can cause Excel to treat the records above and below it as separate blocks, which may leave some dates out of the filter. If there are notes or totals beside the records, keep them outside the range you intend to filter.
- Select a cell in the data. Click any cell in the list, preferably a heading or a record. You usually do not need to select the entire worksheet or highlight every row. If the data is arranged as an Excel table, skip to step 4; filter arrows should already appear in the table headings.
- Turn on AutoFilter if needed. On the ribbon, choose Data > Filter. Excel adds a drop-down arrow to each heading in the detected data range. On Windows, Ctrl+Shift+L toggles AutoFilter on or off. In Excel for Mac, use Data > Filter if you do not have a convenient shortcut assigned; keyboard shortcuts can vary with the Mac keyboard and Excel settings. In Excel for the web, choose Data > Filter.
- Open the date column menu. Click the arrow in the heading for the date field, not the arrow in a different column. The menu includes a search box, a checklist of values, and, for recognized dates, a Date Filters option. If you only see text filters, or the dates appear as ordinary text values, Excel may not recognize the column as dates; see Troubleshooting before continuing.
- Filter for one exact date. For a short checklist, clear Select All, select the date you want, and choose OK. If the list is long, type the date or part of it in the search box, then select the matching entry and choose OK. Another route is Date Filters > Equals, enter or select the date in the dialog, and confirm. Use the date picker or a date format Excel recognizes on your computer. The filtered rows are the records whose date matches the value you chose.
- Filter a continuous date range. Open the same arrow and choose Date Filters > Between. Enter a start date and an end date, then confirm the dialog. Excel includes dates on the boundary dates as well as dates between them. For example, a range from March 1 through March 31 includes both March 1 and March 31. Check the selected comparison options in the dialog before you apply it, especially if you want dates strictly after or before a boundary instead of including it.
- Choose dates from different parts of the calendar. If you want several separate dates rather than every date in a range, use the checklist: clear Select All, tick each date needed, and select OK. This works well for a few individual days or several dates in one month. If there are many dates spread across a large list, search for each value or use a helper column as described in Tips. A Between filter would also include all dates between the first and last selected dates, so it is not a substitute for choosing nonconsecutive dates.
- Review the result and clear it when finished. Look for the filter icon in the heading and check that the visible rows are the ones you intended. Other column filters can remain active at the same time, so a missing record might be excluded by a filter in another field. To remove only the date condition, open that column’s menu and choose Clear Filter From [column name]. To remove all active filters, choose Data > Sort & Filter > Clear, or use the Clear command on the Data tab. Clearing a filter shows hidden rows again; it does not delete them.
Excel for Mac and Excel for the web use the same general approach: turn on or use the column filter, open the date column menu, and select the dates or date condition. The exact wording or arrangement of filter choices can differ slightly by version. If a Date Filters submenu is not available, select dates from the checklist or check that the values are real dates. On a shared workbook, confirm that your filtering is not disrupting another person’s view; Excel tables and coauthoring features can handle views differently depending on the file and version.
Common Mistakes
- Filtering dates that are actually text. A value such as 03/15/2026 can look like a date but be stored as text, especially after importing a CSV or copying from a website. Text values may sort alphabetically, and Excel may offer text filters instead of date filters. Convert the entries to real dates before relying on date conditions.
- Using a range for separate dates. A Between condition includes all dates in between its endpoints. To display March 3 and March 18 but not the days between, select those two entries in the checklist instead.
- Forgetting that other filters are active. A date may meet the condition but still be hidden because another column is filtered. Check for filter icons in other headings and clear those conditions temporarily when checking the result.
- Assuming the displayed format changes the stored date. Changing a cell from month/day/year to day/month/year changes how Excel displays a numeric date; it does not necessarily correct text values or alter the date itself. Do not use formatting alone as proof that a conversion worked.
- Overlooking times attached to dates. A cell may contain March 15 at 2:30 p.m. even though its number format displays only March 15. A filter for exact equality to March 15 may not include every record from that day if the stored values include times.
Tips
- Use a table for data that grows. Select the data and choose Insert > Table, confirming that My table has headers is checked. Tables add filter arrows and generally extend to include new rows, reducing the chance that later records fall outside the filtered range. Avoid placing unrelated data immediately beside the table, since Excel may include adjacent cells when creating it.
- Keep dates consistent. Use one date-entry convention in a column and avoid mixing dates with labels such as Pending or Not supplied. Excel’s interpretation of an entry like 4/5/2026 depends on regional settings: it could mean April 5 or May 4. A four-digit year helps distinguish the year but does not resolve every day/month ambiguity.
- Use a helper column when you need repeatable rules. For example, with date-time values in A2:A100 and the date to test in D1, enter
=INT(A2)=D1in B2 and fill it down. This assumes A2 contains a valid Excel date-time and D1 contains the target date at midnight; for a timestamp on March 15, 2026, D1 would hold that date. INT removes the time portion, so the formula returns TRUE for any time on the target day and FALSE for other days. Filter the helper column to TRUE. If the source dates are text, this formula may not work until you convert them. - Use a date range to include every time on a day. When filtering date-time data, set the lower condition to on or after the target day and the upper condition to before the following day, using AND in the custom filter dialog. For March 15, for example, use March 15 as the inclusive lower limit and March 16 as the exclusive upper limit. This includes timestamps throughout March 15 without including midnight at the start of March 16.
- Keep an unfiltered view in mind. Filtered rows are hidden, not removed. Before copying, deleting, or editing records, check whether a filter is active. If you need a complete list again, clear the filter rather than rebuilding the data.
Troubleshooting
Date Filters is missing: Check whether the cells are stored as text. Select a sample cell and look at the formula bar and alignment, but do not rely on alignment alone because formatting can change it. You can test the value in a blank cell with =ISNUMBER(A2), assuming the sample date is in A2. A TRUE result indicates Excel stores it as a number, as dates normally are; FALSE often means it is text. If you need to convert a whole column, first make a copy, then select the column and choose Data > Text to Columns. Follow the wizard, choose the appropriate date order under Column data format if prompted, and finish. Verify several converted dates before filtering.
The expected date does not appear in the checklist: Clear the search box and check that Select All is not hiding the values you need. Also inspect the source column for blank cells, inconsistent years, or a second date format that Excel interpreted differently. If the records were added recently, confirm that the filter range or table includes the new rows.
The filter returns no rows: Reopen the filter and inspect the condition and the date as Excel interpreted it. A regional date-order mismatch can make a typed date mean a different day. Try selecting the date from the checklist instead of typing it. If the data includes times, use the full-day range method in Tips or a helper column that removes the time.
Some rows appear to be missing: Check all column headings for active filter icons, not just the date heading. Clear other filters temporarily and confirm that hidden rows are not simply outside the current table or AutoFilter range. Also check for grouped or hidden rows; a filter can hide rows in addition to rows hidden manually.
Dates sort in a strange order: This usually points to text dates, mixed date formats, or inconsistent entries. Convert the column to real dates using the correct order for the source data, then apply a consistent number format from Home > Number. If a source entry is ambiguous, verify its intended month and day rather than guessing based on how it looks.
Frequently Asked Questions
Can I filter for one exact date?
Yes. Use the date checklist to select that date, or open Date Filters > Equals and specify it. If the cells include times, use a full-day range or helper column so timestamps on the chosen day are included.
Can I filter for dates in two separate periods?
A single Between filter covers one continuous span. For separate periods, select the needed dates from the checklist if there are only a few. For larger or regularly changing sets, add a helper column that marks whether each record belongs to one of the periods, then filter the helper results.
Can I filter by month or year rather than exact dates?
Often, yes. Open the date filter menu and look for All Dates in the Period, then choose a month, quarter, or year if that option is available. You can also use a Between filter with the first and last dates of the desired period. The period choices depend on Excel recognizing the column as dates.
Why does my date filter include or exclude unexpected records?
Check for times hidden by the cell format, date-order differences, and other active filters. For timestamp data, a condition that equals midnight may miss records later in the day. Use a lower bound at the start of the day and an exclusive upper bound at the start of the next day.
Does filtering delete the other dates?
No. Filtering hides rows that do not match; the data remains in the worksheet. Clear the filter to show those rows again. Take care when copying or deleting filtered data, because those actions can affect the selected or visible records in ways that differ from simply viewing them.
Do these steps work in Excel for Mac and Excel for the web?
The core filter process is similar in both, although controls and menu wording can vary by release. On Mac or the web, use the Data tab and the date column’s filter arrow if a Windows shortcut or menu position differs.
Related
- How to Enable AutoSave in Excel for Automatic Saving
- How to Enable Copy and Paste in Excel When It Stops
- How to Enable Autofit in Excel for Columns and Rows
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Split Cell String: Formulas, Tools, and FixesTo split a cell string in Excel for Microsoft 365, enter =TEXTSPLIT(A2," ") in an empty cell to…
- Excel Formula for Adding Hours on a Timesheet CorrectlyTo add timesheet hours in Excel, use =SUM(B2:B8) when the daily durations are in cells B2 through B8.…
- How to Copy a Formula in Excel to Other Cells SafelyTo copy a formula in Excel, select the cell that contains it, then drag its fill handle into…
- Excel FV Compound Interest: Formula, Examples, and TipsIn Excel, use the FV function to calculate a value in the future after interest compounds: =FV(rate,nper,pmt,[pv],[type]). For…
- Filter Excel Table Without a Header: What WorksExcel filtering needs a header row: if you apply Filter to a headerless range, Excel treats its first…
- Percentage Change Calculator Formula in Excel: ExamplesTo calculate percentage change in Excel, subtract the old value from the new value, then divide by the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.