Excel Filter Dates Within a Range: Steps and Fixes

Formulas & functions · Updated November 19, 2026

To filter Excel dates within a range, select a cell in your data, choose Data > Filter, open the date column’s dropdown, and select Date Filters > Between. Enter the start and end dates and confirm; Excel displays matching rows while hiding the rest.

What a date-range filter does

An AutoFilter is a view of your existing data, not a deletion or a permanent rearrangement. When you filter a date column, Excel hides rows that do not meet the criteria, so you can focus on a particular week, month, quarter, or custom period. Clear the filter to show all rows again.

Excel stores recognized dates as serial numbers, with a whole-number portion for the day and a fractional portion for the time. That is why date filters can compare dates in order and why a cell displaying only a date may still contain a time. Formatting controls how a value looks; it does not by itself turn text into a real Excel date.

A range normally means that both endpoints are included. For example, a range from April 1 through April 30 includes those dates as well as the dates between them. If your records contain times, however, the end-of-day detail matters; a later section explains how to include every time on the final date.

Apply the filter from the ribbon

For a straightforward list in Excel for Microsoft 365 on Windows, use these steps:

  1. Make sure each column has a header, such as Order Date, and that there are no completely blank rows splitting the list.
  2. Click a cell in the data. If you want to filter only a specific range, select that range, including its headers.
  3. Choose Data > Filter. Excel adds dropdown arrows to the header row. The Windows shortcut Ctrl+Shift+L toggles AutoFilter on or off.
  4. Open the dropdown in the date column. Choose Date Filters, then Between. If Excel shows Text Filters instead, it may not recognize the column as dates.
  5. Set the first condition to on or after your start date and the second to on or before your end date. Keep And selected when you want a date to satisfy both conditions.
  6. Confirm the dialog. Check the visible rows and, if useful, the status bar or row numbers to see that the intended records remain.

Excel may offer a calendar-style hierarchy in the dropdown, with years, months, and days that can be expanded or collapsed. That is useful for selecting a whole month or year, but Between is more direct when you need exact endpoints or a range that crosses a month boundary.

On Excel for Mac, the Data tab also has Filter, and the filter dropdown provides date criteria when the values are recognized as dates. The ribbon layout and dialog appearance can differ slightly from Windows. Excel for the web has filtering controls too, though some commands and menus may be arranged differently; the same principle applies: set a lower and upper date bound.

Choose the right date criteria

Use Date Filters > Between when your start and end dates are fixed and you want a quick, readable setup. For example, to show transactions from April 1 through April 30, enter those two dates as the lower and upper bounds. If your dates are displayed in a regional format, check that Excel interpreted each entry as the date you intended; 4/5/2026 can mean April 5 or May 4 depending on locale.

For more control, open the date dropdown and choose Custom Filter if it is available. Set two conditions and join them with And. A lower condition of on or after April 1 and an upper condition of before May 1 is often a better choice when timestamps are present, because it includes every time on April 30 but excludes midnight on May 1.

Use Or only when you deliberately want either condition to qualify. For example, a date that is before April 1 OR after April 30 is outside the month, not within it. Choosing Or by mistake is a common reason a filter seems to return almost everything.

Handle dates that include times

A date-time value such as April 30 at 3:45 p.m. is greater than April 30 at midnight. If a filter’s upper bound is interpreted as April 30 at midnight, records later that day may be omitted. This is easy to miss when the cells are formatted to display only the date.

For a date range that includes all times on the ending day, use an exclusive upper bound: on or after the start date, and before the day after the end date. For April 1 through April 30, that means starting on April 1 and filtering before May 1. This comparison includes April 30 at 11:59 p.m. while leaving out May 1.

Another option is to add a helper column that extracts the date portion, then filter that column. With date-time values in A2:A100, a helper formula in B2 can be =INT(A2); fill it down and format the helper values as dates if needed. INT removes the fractional time portion from a positive Excel date-time serial. Filter the helper column using the desired inclusive dates. Keep the original timestamp column if the time is useful for analysis.

Use a formula to return matching rows

A formula can produce a separate, live list of matching records instead of hiding nonmatching rows in the source. This is useful for a report or a dashboard, but it does not replace AutoFilter when you simply want to inspect and sort the original list.

Assume actual Excel date-time values are in A2:A5, corresponding descriptions are in B2:B5, and the start and end dates are in E2 and F2. If the four records are April 1 at 9:00 a.m., April 15 at 2:30 p.m., April 30 at 11:00 p.m., and May 1 at midnight, set E2 to April 1, 2026, and F2 to April 30, 2026. Enter this formula in an empty cell:

=FILTER(A2:B5,(A2:A5>=E2)*(A2:A5<F2+1),"No matching rows")

The formula returns the first three records and excludes May 1. The multiplication combines the two tests as an AND: each row must be on or after the start date and before the day after the end date. FILTER is available in Microsoft 365 and Excel 2021 or later; the result spills into cells below and to the right, so keep that output area clear. If your source contains date-only values, the same formula still works. If the end date is meant to be exclusive rather than inclusive, compare directly with F2 instead of F2+1.

Check whether Excel recognizes the values as dates

If Date Filters does not appear, or the range returns unexpected results, inspect the source values. Text that looks like a date is not necessarily a date value. Common causes include imported CSV data, leading apostrophes, extra spaces, inconsistent date formats, and dates interpreted using a different regional order.

  • Click a cell and check the formula bar. A real date may display in a different format when you apply a date number format; text often remains unchanged.
  • Try changing the cell format to a date using Home > Number Format. Formatting alone will not convert text, but it can reveal whether the underlying value is numeric.
  • For imported data, use Data > Text to Columns and follow the steps to specify the correct date order when the wizard offers a date format choice. Work on a copy or an extra column if you need to preserve the original values.
  • Check for blanks or mixed entries in the date column. A column with dates, text labels, and errors may not behave as expected when filtered.

Do not rely on sorting alone to diagnose the issue. Text dates can sort alphabetically rather than chronologically, which may look plausible for some values but produce the wrong order overall. Converting the values to real dates before filtering is safer.

Filter a table and keep the source organized

If your data is a consistent rectangular list, converting it to an Excel table with Insert > Table can make ongoing work easier. Confirm that My table has headers is selected. Tables include filter dropdowns in their header row, and their ranges generally expand when you add records directly below them. Filtering a table by date uses the same date criteria as filtering a regular range.

Keep one type of information per column: put dates in the date column, not in a mixture of notes such as April delivery or pending. Avoid merged cells in the data area and repeat relevant values on each record rather than using a heading that applies visually to several blank rows. A clean layout helps Excel identify the full list and makes the filter easier to maintain.

Filtering does not change the order of the underlying records. If you also want the visible dates in chronological order, use the dropdown’s sort options or the Data tab’s sort controls after applying the filter. To show all records again, open the filtered column’s dropdown and choose Clear Filter From [column name], or use Data > Clear to clear filters across the range.

Common problems and practical fixes

If rows you expect are missing, first verify the start and end dates and whether the final date contains times. Then check that the filter is applied to the entire list, not a partial selection that leaves related columns outside the filtered range. A blank row inside a list can also cause Excel to treat the records below it as a separate region.

If the dropdown offers only text options, convert the date text to real dates and reapply the filter. If the filter appears to include dates outside the range, check whether those cells are text, whether an Or condition is selected, or whether another filter is also active in a different column. Multiple column filters work together, so a row must meet all active column filters to remain visible.

When a workbook is shared, remember that another person may see a different filtered view if the workbook is saved with filters active or if they apply their own filters. For a report that must always show a defined date window, document the criteria or use a separate formula-driven output rather than assuming every reader will have the same view.

Frequently Asked Questions

Can I filter Excel dates between two dates, including both endpoints?
Yes. Choose Date Filters > Between and set the criteria to on or after the start date and on or before the end date. If the cells contain times, use a before-the-next-day upper bound to include the entire final date.

Why does Excel show Text Filters instead of Date Filters?
Excel likely sees one or more entries as text rather than date values, or the selected column contains mixed data. Convert text dates to real dates, check the regional date order, and apply the filter again.

How do I filter a whole month?
Use the dropdown’s date hierarchy to select the month, or use a custom range from the first day of the month through the last day. For timestamps, use the first day as the lower bound and the first day of the next month as an exclusive upper bound.

Can I filter dates dynamically, such as the last 30 days?
Yes. Date Filters may include relative options such as Today, Tomorrow, Yesterday, This Week, and Last Month, depending on the Excel interface. For a custom rolling period, use a formula-based helper or FILTER formula whose date limits are based on TODAY, and check whether the definition should include today.

Does filtering delete the other rows?
No. AutoFilter hides rows that do not meet the criteria; it does not delete them. Clear the filter to display the complete list, and save a copy before making separate edits if you are concerned about changing source data.

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.