Excel Won’t Filter by Dates? Fix the Data and Sort

Errors & fixes · Updated November 19, 2026

If Excel won’t filter by dates, the most common cause is that some or all of the entries are stored as text instead of real date values. Select the date column and convert the entries to dates, then reapply the filter using Data > Filter; if the values are already dates, check for mixed formats, hidden rows, blank cells, or a filter range that excludes some records.

How Excel date filtering works

Excel stores a recognized date as a number representing a day in its date system, then displays that number in a date format such as 3/8/2025 or 8-Mar-2025. That means a date can look correct on the screen while still being text that Excel cannot compare or group as a date. A true date can also look like a number if its cell format is General or Number; that does not necessarily mean the value is wrong.

When a column contains real dates, the filter menu can offer date-specific choices such as Before, After, Between, and filters for particular years, months, or days. If the menu offers only text-oriented choices, or treats each date-looking entry as a separate label, Excel may not recognize the column consistently. Filters act on the underlying cell values, not just the way those values appear.

Check whether the entries are real dates

Start with a quick visual and behavioral check. Select a few cells and look at the formula bar and the Number Format box on the Home tab. A date number format is a useful clue, but formatting alone cannot turn text into a date. You can also temporarily change a suspect cell’s format to General: a real date typically displays as a serial number, while text generally remains text. Restore the date format afterward.

Try sorting the column from oldest to newest. If entries sort in an unexpected order—for example, dates beginning with 1 appear before dates beginning with 2 regardless of year—the column may contain text or inconsistent values. Sorting is a diagnostic, not a definitive test: mixed date formats can produce a partly plausible order, so inspect several records and test the cells that appear out of place.

Look for leading apostrophes, spaces before or after the value, or imported symbols. A leading apostrophe may not be visible in the cell itself, but it can cause a date-looking entry to be treated as text. A column can contain both genuine dates and text dates, so checking only the first row is not enough.

Convert text dates into Excel dates

For a column of consistently formatted imported dates, Text to Columns can convert text to real dates without building a new formula. Make a copy of the data first if it is important, then select the date cells and choose Data > Text to Columns. In the wizard, choose Delimited and select Next, leave delimiters unchanged and select Next, then choose Date and the order that matches the source values, such as YMD or DMY. Select Finish. Verify a sample afterward by applying a date format and checking that the filter menu now offers date filters.

The order you choose matters. For example, 04/05/2025 could mean April 5 or May 4, depending on the source convention. Do not select an order based on how the current computer displays dates; use the format used by the system or file that supplied the data. If the column contains multiple conventions, convert separate groups carefully rather than applying one interpretation to everything.

For a consistent ISO-style text date such as 2025-03-08, a formula can build a true date from its year, month, and day parts. With text values in A2:A100 and the first value in A2, enter this in B2 and fill it down:

=DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2))

For A2 containing 2025-03-08, the formula returns the Excel date March 8, 2025. Format the results as dates, check that the conversion is correct, and then copy the results and use Paste Special > Values if you need to replace the original text column. This particular formula assumes every entry has the same ten-character YYYY-MM-DD layout; it is not suitable for mixed or differently ordered text dates.

Reapply the filter to the complete data range

After fixing the values, make sure the filter covers every row. Click a cell in the data and choose Data > Filter. If the range is interrupted by completely blank rows or columns, Excel may detect only part of the list. A filter can appear to work while newer records below the detected range remain visible and unaffected. Remove unintended blank rows within the dataset, or select the full rectangular range before turning on Filter.

For a growing list, convert the range to an Excel table with Insert > Table, confirm that the selected range is correct, and indicate whether the table has headers. Tables automatically extend when records are added directly below them, which helps keep new dates inside the filtered range. Use one clear header row; repeated headers, merged cells, or blank header names can make a list harder to filter reliably.

If the filter arrows are already present, open the date column’s dropdown and choose Clear Filter From [column name] if that option is available, then set the desired condition again. On the Data tab, Clear in the Sort & Filter group clears filters across the range. Clearing a filter does not delete records; it makes hidden rows visible again. Check that no other column has an active filter that is hiding the rows you expect to see.

Choose the right date filter

For a simple range, open the dropdown in the date header, point to Date Filters, and choose Between, Before, or After. Enter the boundaries and confirm. Use Between when you need both an earliest and latest date, such as records from March 1 through March 31. Excel’s displayed date format can vary with regional settings, so read the dates in the dialog carefully before applying the condition.

For a calendar period, expand the year and month groups in the dropdown if they are available, or use Date Filters to specify a range. A month-name filter may include all records in that calendar month across the years, depending on the choice you make in the date tree. If the year matters, select the specific year and month or enter explicit date boundaries rather than relying on a month label alone.

Dates that also contain times are still numeric date-time values: the date is the whole-number portion and time is the fractional portion. For instance, two entries displayed as March 8 may actually be March 8 at 9:00 a.m. and March 8 at 4:00 p.m. If a filter seems to miss records near a boundary, check the underlying values and include the full intended date range. A cell formatted to hide the time can make those differences hard to spot.

Common causes beyond text dates

  • Mixed regional formats: A file imported from another locale may use month-day-year while the computer expects day-month-year. Ambiguous values can be misread or left as text.
  • Extra spaces or characters: Pasted values may contain spaces, nonbreaking spaces, or a leading apostrophe. Clean or convert the source values before filtering.
  • Blanks and interrupted lists: A completely blank row can split what Excel detects as one data range. Check the boundaries of the filtered range.
  • Hidden rows or other filters: A filter on a different column, manually hidden rows, or a saved view can make it seem as if the date condition is wrong.
  • Formula results: A formula that returns a date-looking text string is not equivalent to a formula that returns a date serial. Check the result type as well as its appearance.
  • Merged cells or inconsistent headers: These can interfere with a clean, rectangular filter range. Keep each record on one row and use a single unmerged header row.

CSV files deserve particular attention. A CSV stores text and separators, not Excel’s cell formats, so Excel interprets values when opening or importing it. If the dates are ambiguous, use Data > From Text/CSV to inspect the import and select an appropriate locale or data type where available, rather than assuming the first automatic interpretation is correct. Menu details can vary slightly across Microsoft 365 updates.

Excel for Mac and Excel for the web

In Excel for Microsoft 365 on Windows, the steps above use the Data and Home ribbon tabs. Excel for Mac also provides filtering and date formatting through its ribbon, although the layout and some dialog wording can differ. Text to Columns is available in desktop Excel; use the date order that matches the source data, and verify the converted results rather than relying on the displayed format alone.

Excel for the web supports ordinary table and range filters, but some import and conversion controls available in desktop Excel may be limited or arranged differently. If you cannot find a conversion option in the web interface, open the workbook in the desktop app and use Text to Columns or the appropriate import workflow. Avoid changing a workbook’s regional settings just to make one ambiguous column appear right: confirm the source convention first, because a setting change can affect how other values are interpreted.

Prevent date-filter problems in future files

Set a consistent date convention at the point where data is entered or imported. Keep actual dates in the date column, store explanatory text in a separate column, and avoid mixing entries such as 2025-03-08, 8 Mar 2025, and “March 8” in the same field. Apply a display format only after confirming the values are genuine dates; changing the format of text alone does not convert it.

Before sharing a workbook, check a few early, middle, and recent records, confirm that the filter range includes the full list, and test a date range whose expected results you can identify. If the data comes from a recurring export, repeat the import with a deliberate date interpretation each time. These checks are especially useful when reports combine sources from different countries, software systems, or file formats.

Frequently Asked Questions

Why does Excel show Text Filters instead of Date Filters?

Excel likely sees the selected column as text, or the column contains inconsistent mixtures of text and date values. Convert the values to real dates, check a few cells, then clear and reapply the filter.

Why does Excel sort my dates alphabetically?

Alphabetical-looking order often means that at least some entries are text. Check for mixed formats and extra characters, then convert the column using the correct source date order. A display format by itself will not change text into dates.

How do I filter dates between two days?

Open the date column dropdown, choose Date Filters > Between, enter the start and end dates, and confirm. Check whether the data includes times if records at the edges appear to be missing.

Why are some new rows not included in the date filter?

The filter may cover only the original range, particularly if a blank row or column separates later records. Extend the filtered range or convert the data to a table so new adjacent rows are more likely to join it automatically.

Does changing a cell’s format fix a text date?

No. Number formatting changes how a value is displayed, but it does not convert text into an Excel date value. Use Text to Columns with the correct date order, or use a conversion formula appropriate to the text layout, then verify the result.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.