Filter Excel by Date: Steps, Custom Ranges, and Fixes

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 select a date or use Date Filters for a range or time period. Excel hides rows that do not match; it does not delete them, so clearing the filter restores the full list.

How Excel date filtering works

Excel stores recognized dates as serial numbers, with the number representing a day and any decimal portion representing a time. The displayed format, such as 11/2/2026 or November 2, 2026, is separate from the value Excel uses to sort and filter. When a column contains real date values, its filter menu usually offers date-specific options and may organize the checkbox list into years, months, and days.

A filter affects which rows are currently visible. It does not rearrange the underlying values unless you also sort, and it does not remove data. Filters on different columns work together: a date filter and a city filter, for example, show rows that satisfy both conditions. This makes filtering useful for exploring a working list without changing the original records.

For the filter to behave predictably, use one header row and keep each record on a single row. A simple table might have columns named Order Date, Customer, and Amount, with one order per row. Avoid merged cells and blank rows within the dataset, since they can cause Excel to identify only part of the data as the filter range.

Apply a basic date filter

Click a cell inside the data range. If the data is already an Excel table, its header filters may already be available.
On the ribbon, select Data > Filter. Filter arrows appear beside the column headings. You can also use Home > Sort & Filter > Filter.
Open the arrow beside the date column heading. If needed, clear Select All, then check the date or dates to display. Expand or collapse year and month groups to find a particular day.
Select OK. Excel displays matching rows and marks the filtered column’s arrow with a filter icon.

For example, in an order list, selecting March 14, 2026, in the Order Date filter shows records with that date. To show several specific dates, check each one before selecting OK. The checkbox list is handy for a few chosen dates, but a date condition is usually faster for a continuous span.

To remove a filter from just one column, open its menu and choose Clear Filter From [column name]. To clear all active filters while keeping the filter arrows, use Data > Clear. To turn off the arrows, select Data > Filter again. Clearing or turning off a filter reveals hidden rows; it does not erase them.

Use Date Filters for a range or period

Open the date column’s filter menu and point to Date Filters. The menu commonly includes choices such as Before, After, Between, Today, This Week, This Month, This Quarter, This Year, and Year to Date. Available relative periods can also include previous or next periods. Choose the condition that fits the question, enter dates if prompted, and confirm it.

Between is useful when the start and end dates are known. For instance, to review orders from April 1 through April 30, 2026, choose Date Filters > Between and enter those two dates. Check the dialog’s comparison options and the values it displays before confirming, especially if your data includes times as well as dates. Excel’s date interpretation can depend on regional settings, so use a date format that is unambiguous in your installation.

Relative options are useful for recurring checks. This Month filters according to the current date, so the results change as time passes; it is not a fixed selection of a month you type in. For a past month that should remain the same next time you open the workbook, select the actual month and year in the date list or use a fixed custom range instead.

Choose the right filtering method

One or a few exact dates: Use the checkbox list in the date menu. It is direct when you can see the required dates.
A continuous date span: Use Date Filters > Between, or use Before or After when you need a one-sided cutoff.
A changing period: Use a relative option such as This Month or Year to Date when the filter should follow the current calendar.
More than one condition: Use the custom filter dialog when you need to combine comparisons, or add filters in other columns to narrow the visible records.

Filtering is different from sorting. A date sort changes the order of visible records, while a filter decides which records are shown. If the goal is to inspect the oldest or newest entries, sort the date column from oldest to newest or newest to oldest. If the goal is to isolate a period, filter it. You can apply both when useful.

Prepare date data before filtering

The most common reason date filters seem missing or inconsistent is that some entries are text rather than dates. A value that looks like 3/14/2026 may be stored as text, especially if it was imported from a CSV file, copied from a website, or entered using a format Excel does not recognize under the computer’s regional settings. Text entries may sort alphabetically, appear as separate items, or fail to respond to date conditions.

Check a questionable cell by selecting it and looking at the formula bar and number format. Changing the cell format to a date format does not convert text into a true date; it changes how a numeric value is displayed. If conversion is needed, use Data > Text to Columns and review the date format settings before completing the conversion, or correct the source data and import it with the appropriate date interpretation. Make a copy first if the conversion could affect important source values.

Use one consistent date convention in a column, and confirm whether entries such as 04/05/2026 mean April 5 or May 4.
Remove leading or trailing spaces and check for apostrophes that may force values to be text.
Keep headings in a single, nonblank header row and avoid merged header cells.
Check for blank rows or columns that split the data into separate regions. Converting the range to a table through Insert > Table can help Excel keep the records and filter controls together.

Filter dates that include times

A date-time value contains more detail than the date shown on the worksheet. For example, two records may both display as April 30, while their stored values represent April 30 at 9:00 a.m. and April 30 at 4:30 p.m. If a custom condition uses an end boundary at midnight at the start of April 30, it may not include the later records that day.

When you need a whole calendar day from a column that includes times, set the lower boundary to the start of that day and the upper boundary to the start of the following day, using a greater-than-or-equal comparison for the lower limit and a less-than comparison for the upper limit. In the Custom AutoFilter dialog, set the two conditions to use AND so both must be true. For April 30, that means including values from April 30 at midnight up to, but not including, May 1 at midnight. This approach includes every time on April 30 without relying on an assumed last second of the day.

If the time is not relevant to the analysis, you can also add a separate date-only helper column or adjust the source data structure. Do not simply change the number format and assume the time has been removed: formatting can hide the time while leaving it in the underlying value.

Troubleshoot date filter problems

If the menu shows Text Filters instead of Date Filters, Excel may not recognize the entire column as dates. Mixed entries are a frequent cause: some rows may hold true dates while others contain text, blanks, notes, or error values. Inspect the column, convert text dates consistently, and reopen the filter menu. If the filter range skipped rows, turn off the filter, select the complete dataset, and apply it again; an Excel table can make the range easier to maintain as new records are added.

If a date you expect is missing from the checkbox list, check whether another column is also filtered. Filters combine, so a matching date can still be hidden because its row fails another condition. Also check the year and month groupings, scroll the list, and clear any search text in the filter menu. If you recently added data, confirm that it is inside the filtered range or table.

If a period such as This Month returns unexpected rows, verify the computer’s current date and inspect whether the source entries are real dates or date-times. Relative periods follow the current calendar, while a manually selected month is fixed. If the result still looks wrong, clear filters, correct the underlying values, and apply the conditions again rather than relying on the displayed format alone.

Alternatives for larger or recurring analyses

For a one-time check, the regular column filter is usually the simplest choice. If the same report is reviewed repeatedly, an Excel table is useful because its filter controls stay attached to the table as rows are added. A PivotTable offers another route: place the date field in the Rows area, then filter or group the summarized records by the periods relevant to the report. PivotTable layouts and refresh behavior differ from filtering the original rows, so refresh the PivotTable after changing its source data.

For a reusable report that should display matching rows in a separate area without hiding source rows, Microsoft 365 also has the FILTER worksheet function. It is a different tool from the header dropdown: it returns an array of matching records and requires room for the results to spill. Use it when a live extracted view is needed, but use the regular filter when you simply want to inspect or edit rows in the source list. Keep the source dates consistent whichever approach you choose.

Frequently Asked Questions

How do I filter Excel by month and year?
Open the date column’s filter arrow, expand the year and month groups, and select the dates for the month you want. For a fixed month, verify the year as well; selecting a month name alone could include matching dates from multiple years depending on the menu selection.

Can Excel filter dates between two dates?
Yes. Open the date filter menu, choose Date Filters > Between, enter the start and end dates, and confirm. If the column contains times, use a start-of-day lower boundary and a next-day exclusive upper boundary to include a complete final day.

Why does Excel show Text Filters instead of Date Filters?
Excel may have stored the entries as text, or the column may contain a mixture of text and date values. Convert the text entries to real dates using a method that matches their source format, then apply the filter again.

Does filtering dates delete rows?
No. Filtering hides rows that do not meet the selected condition. Use the filter menu’s clear option or Data > Clear to show them again. Deleting visible rows is a separate action and should not be confused with filtering.

How do I show all dates again?
Choose Clear Filter From the date column in its menu, or select Data > Clear to remove active filters across the range. The filter arrows remain available unless you turn off Data > Filter.

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.