Date Filter in Excel: Find Dates, Months, and Ranges

Formulas & functions · Updated November 19, 2026

To filter dates in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the arrow in the date column’s header, and choose a date option under Date Filters. For a custom period, choose Date Filters > Between and enter the start and end dates; Excel then hides rows outside the criteria without deleting them.

What a date filter does

A date filter displays only the records that meet a date-based condition, such as orders from this month or appointments after a chosen day. The rows that do not match are temporarily hidden, not removed, so clearing the filter brings them back. This makes filtering useful for reviewing a subset of a list while keeping the original data intact.

Excel can filter dates correctly when the cells contain actual date values. Internally, Excel stores dates as serial numbers and uses number formatting to show them as calendar dates. A cell that looks like “Apr 12, 2026” might therefore be a true date, while a cell containing text that looks identical may not be recognized as one. That distinction explains many date-filter problems.

For reliable results, keep one record per row, put a single header row at the top, and use a consistent date column. Avoid blank rows or merged cells inside the data range, because they can make the range harder to filter as one continuous list.

Apply a basic date filter

  1. Click a cell in the data range. If the data is an Excel Table, click anywhere inside it; its header row normally already has filter arrows.
  2. For a regular range, select Data > Filter. Excel adds dropdown arrows to the header row. The Windows shortcut Ctrl+Shift+L toggles AutoFilter on and off.
  3. Open the dropdown arrow in the column that contains dates. If Excel recognizes the values as dates, the menu includes date-specific options.
  4. Choose a date condition, or select individual dates in the checklist. Select OK to apply the filter.

On Excel for Mac, the Data tab also provides the Filter command; ribbon layout and shortcut behavior can vary with the Mac version and settings, so use the command on the ribbon if the Windows shortcut does not apply. Excel for the web offers filtering from the column header dropdown as well, though some dialogs and ribbon details can look different.

Use the built-in date filter options

Excel’s Date Filters menu includes useful relative periods and comparisons. Depending on the selected data and Excel version, options can include today, yesterday, tomorrow, this week, last week, next month, before, after, and between. Relative choices are handy for lists that change over time: a filter for “This Month” can show a different set of records as the calendar advances.

When Excel groups recognized dates in the dropdown, it may show a year-and-month tree. Expand or collapse the levels and select the dates or months you want. This is convenient for choosing a calendar month, but check the year as well: January 2025 and January 2026 are separate periods. If your aim is every January across multiple years, ensure that the selections include January under each relevant year or use a suitable custom condition.

Use the checklist for a short list of specific dates, such as selecting three delivery days. Use the Date Filters conditions for a rule, such as “after May 1” or “during this quarter.” A rule is easier to maintain when new records are added than a long set of individually checked dates.

Filter a custom date range

To show dates within a period, open the date column’s dropdown and choose Date Filters > Between. Enter the beginning and ending dates in the custom filter dialog, using a date format Excel recognizes under your regional settings, then confirm. For example, to review transactions from April 1 through April 30, set the lower limit to April 1 and the upper limit to April 30 of the same year.

Read the comparison labels in the dialog before accepting the filter. If it offers “is after or equal to” for the lower boundary and “is before or equal to” for the upper boundary, those settings include both boundary dates. If you choose strictly “after” or “before,” records on the boundary may be excluded. This matters when a report must include the first and last day of a period.

For a rolling range, such as the last 30 days, a fixed pair of dates will not automatically move forward. Reapply the filter with updated dates when needed, or use a different reporting method if the range must update dynamically. A normal AutoFilter is a practical interactive view, not a permanently changing report formula.

Dates that include times

A date-and-time value contains both a date and a time, even if the cell is formatted to display only the date. For example, two records can both appear as “June 10” while one contains 9:00 a.m. and the other 4:30 p.m. A criterion that matches the date exactly may behave differently from a range that includes all times on that date, depending on the comparison and the underlying values.

For a period that must include every timestamp on the final day, pay particular attention to the upper boundary. A cutoff at midnight at the start of that day can leave out later times. In a custom filter, a boundary that includes the date through its displayed day is often appropriate; for precise time-based reporting, inspect the actual values and use a clearly defined start and end time. Another option is to filter from the start of the first day through the start of the day after the period, using criteria that include the start but exclude the next day.

Do not assume a date display reveals the full stored value. Temporarily apply a date-and-time number format or inspect the formula bar if results seem inconsistent. Formatting changes what is shown, not the underlying timestamp.

Why a date filter may not work

If the dropdown shows Text Filters instead of Date Filters, or dates appear as unrelated text entries, Excel may be treating the column as text. Common causes include importing a CSV with a different date order, leading apostrophes, spaces, or mixed values such as dates and words in the same column. For example, “04/05/2026” can be interpreted differently in regions that use month/day/year and day/month/year formats.

  • Check the values: Select a few cells and inspect the formula bar and number format. A date-looking display alone does not prove that the value is a real Excel date.
  • Check for mixed content: Look for blanks, labels, or malformed entries among the dates. Correct or separate these values before filtering.
  • Convert imported text carefully: Use Data > Text to Columns when appropriate and specify the correct date order in the conversion steps. Make a copy first if the source data is important, and verify a few converted dates against the original.
  • Check the active range: Confirm that the filter includes the full list and that each column has a clear header. If new rows sit outside the filtered range, they may not appear in the results.
  • Clear other criteria: A filter on another column can also hide rows. Use that column’s dropdown to clear its filter, or review all active filter arrows.

Be especially cautious with ambiguous text dates. Changing the cell format to “Date” does not necessarily convert text into a date value; formatting changes display, while conversion changes the stored value. After converting, test the filter and confirm that dates sort in chronological order rather than as text.

Tables, PivotTables, and other ways to narrow dates

For a regularly updated list, converting the range to an Excel Table with Insert > Table can make filtering and expansion easier. Tables provide header dropdowns, and new rows added directly below a table are generally incorporated into it. A Table does not fix invalid text dates, however; the date column still needs consistent, recognized values.

PivotTables summarize records rather than simply hide rows in the source list. Their field dropdowns can filter date fields, and Excel may group dates into years, quarters, or months. A PivotTable is useful when the question is “How many sales occurred each month?” rather than “Show me each original transaction from this month.” Refresh the PivotTable after changing its source data so the summary reflects updates.

For a quick visual review, ordinary AutoFilter is usually the simplest choice. For repeatable summaries, use a PivotTable; for a fixed set of selected records, use a table filter or copy the visible rows to a separate analysis area. These methods serve different purposes, so choose based on whether you need to inspect records, summarize them, or preserve a separate result.

Clear or change a date filter

To remove only the date condition, open that column’s dropdown and choose Clear Filter From followed by the column name. To remove filters from the whole range, use Data > Clear. This restores hidden rows but does not delete or alter the source records. To turn the dropdown arrows off, select Data > Filter again; that toggles the filter controls and is different from simply clearing the criteria.

If the filter is still active after clearing the date column, another column may have its own condition. A funnel icon in a header indicates that a filter is applied to that field. Review the headers before concluding that records are missing.

Frequently Asked Questions

How do I filter Excel to show dates between two dates?

Open the date column’s header dropdown, choose Date Filters > Between, enter the start and end dates, and confirm. Check whether the dialog’s comparison operators include the boundary dates, especially if the first or last day must be included.

Can I filter by month without choosing every date?

Yes. If Excel recognizes the column as dates, use the grouped year-and-month checklist in the dropdown and select the month you need. Check the year level too, because the same month occurs in multiple years.

Why does Excel show Text Filters instead of Date Filters?

Excel likely considers the column to contain text rather than date values, or the column has mixed data types. Check imported date order, extra spaces, and inconsistent entries, then convert the text to real dates and verify the results.

Does filtering dates delete the other rows?

No. A filter hides rows that do not match; it does not delete them. Clear the filter to display the full list again. Take care when copying visible cells, since the copied result may contain only the currently displayed records.

How can I include all times on the last day?

Check whether the cells contain timestamps, not just dates. A time later than midnight can fall outside a cutoff at the start of the final day. Use a boundary that includes the intended times, or define the range to end at the start of the following day with an exclusive upper limit when your filtering method supports that comparison.

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.