Filter by Date Range in Excel: Steps and Tips

Formulas & functions · Updated November 20, 2026

To filter a date range in Excel for Microsoft 365 on Windows, open the filter arrow in your date column, choose Date Filters > Between, enter the start and end dates, and select OK. Excel will show rows whose dates fall within that range, so long as the column contains real Excel dates rather than text that only looks like dates.

How Excel date filters work

Excel stores a real date as a serial number and displays it in a date format such as 4/15/2025. That underlying value lets Excel compare dates chronologically, just as it compares numbers. A date filter therefore works on the stored values, not on how attractive or familiar the cells look.

When a filter is applied, Excel hides rows that do not meet the selected condition; it does not delete them. A date range filter is useful for narrowing a long list of orders, appointments, invoices, attendance records, or project tasks to a particular period. You can then review, copy, or summarize the visible records while the rest remain in the worksheet.

Excel’s date filter menu commonly includes choices such as today, tomorrow, this week, next month, and between two dates. The exact relative-date choices depend on the date column and Excel’s current date. Choose Between when you need a fixed start and end date, such as all transactions from April 1 through April 30.

Filter a range using the column dropdown

For a simple list, use the dropdown on the date column. First make sure the data has one header row and that each column contains one type of information. If the list is not already filtered, click a cell in the data and select Data > Filter. Excel adds dropdown arrows to the headers. The Windows shortcut Ctrl+Shift+L toggles filters on or off; on a Mac, use the Data tab’s Filter command if the shortcut differs in your Excel setup.

  1. Select the dropdown arrow in the date column header.
  2. Point to Date Filters, then select Between. If Excel shows a list of years, months, or days instead, confirm that the cells are genuine dates and look for the date-filter commands in the menu.
  3. Enter the beginning date in the first condition and the ending date in the second. For a complete calendar month, use its first and last dates—for example, April 1, 2025, and April 30, 2025.
  4. Leave the conditions joined with And when you want dates on or after the beginning date and on or before the ending date. Select OK.

The rows that remain visible meet the date conditions. A filter arrow may show a filter indicator, which is a useful reminder that the list is narrowed. If the result looks unexpected, check the filter conditions and the underlying date values before changing or deleting any data.

Set inclusive start and end dates

Most date-range questions mean “include both boundary dates.” For example, a range from April 1 through April 30 should include records dated April 1 and April 30. In the Between filter, set the first condition to include dates after or equal to the start and the second to include dates before or equal to the end. Excel’s standard Between date filter is intended to include those boundary dates.

Be especially careful when the date cells also contain times. A value displayed as 4/30/2025 might actually be April 30 at 3:00 p.m.; the cell’s number format can hide the time. A condition that compares timestamps with midnight at the end date may exclude later times that day if the condition is strictly “less than or equal to April 30.” If the built-in filter does not produce the intended result, use a helper column or formula that treats the end date as the start of the following day. The formula section below shows an approach that includes all times on the ending date.

For a rolling period, such as the last 30 days, decide whether you mean the last 30 calendar dates including today or the 30 days before today. Those definitions can differ by one day. Excel’s relative choices are convenient for common periods, while explicit start and end dates are easier to audit when a report must cover a fixed period.

Prepare the data for reliable filtering

Before filtering, check the structure of the list. Each column should have a distinct header, and the date field should not mix dates with notes such as “pending” or “unknown.” Keep one record per row and avoid completely blank rows or columns inside the list; blank breaks can cause Excel to detect only part of the data. If the list is used regularly, convert it to an Excel table by selecting a cell in the data and choosing Insert > Table, then confirming whether the table has headers. Tables automatically provide filter arrows and generally expand as new rows are added.

  • Use consistent dates: Enter dates in a format Excel recognizes for your regional settings, or use the date picker or a consistent import process.
  • Check the cell value: Changing a cell’s number format to Date will not convert text into a real date. If sorting puts dates in an odd order, some entries may be text.
  • Keep headers unique: Clear names such as Order Date or Due Date make it easier to choose the correct filter in a wide table.
  • Watch for imported data: CSV files and copied reports may contain text dates, extra spaces, or inconsistent date order, especially when day and month positions are ambiguous.

A quick diagnostic is to select a date cell and change its number format temporarily. If Excel displays a serial number, the value is likely a real date; if it continues to display the original text, it may need conversion. Do not convert an ambiguous date until you know whether, for example, 03/04/2025 means March 4 or April 3 in the source system.

Filter dates in a PivotTable

If your goal is to summarize records by date rather than inspect every row, a PivotTable may be more useful than a regular filter. Create or select the PivotTable, place the date field in the Rows or Filters area, and use its field dropdown to select the dates or date groups you need. In supported Excel desktop versions, you can also select a PivotTable cell and choose PivotTable Analyze > Insert Timeline, then select the date field. A timeline gives you a visual control for narrowing the PivotTable by periods.

A PivotTable timeline filters the summary, not the source worksheet itself. It can be convenient for dashboards and repeated reporting, but it does not replace checking the underlying records. If a date field cannot be used as expected, verify that the source values are actual dates and refresh the PivotTable after adding or changing source data. Timeline availability and controls can vary by Excel version and platform; use the regular column filter when the timeline command is unavailable.

Use a formula to return matching rows

A formula is useful when you want a separate, automatically updated list rather than hiding rows in the original table. In Microsoft 365 or Excel 2021 and later, the FILTER function can return records that meet date conditions. This is a different approach from the dropdown filter: the results spill into nearby cells, so the output area must be empty.

Assume dates are in A2:A6, the complete records are in A2:C6, and the start and end dates are entered in E1 and F1. For these example rows—April 1, April 15, April 30, May 1, and May 15, 2025—put April 1, 2025, in E1 and April 30, 2025, in F1. Enter this formula in an empty cell outside the source data:

=FILTER(A2:C6,(A2:A6>=E1)*(A2:A6<F1+1),"No matching rows")

The result is the first three records, dated April 1, April 15, and April 30. The less-than comparison against F1+1 includes every time on the end date as well as dates with no time component. The asterisk combines the two conditions as AND: a row must be on or after the start and earlier than the day after the end. If the dates are plain dates with no times, a less-than-or-equal-to end condition can also work. If no records match, the formula displays “No matching rows.”

Keep the criteria cells E1 and F1 as real dates, and ensure the date range in the formula lines up with the full record range. If the source grows, expand the ranges or use a structured table reference. If Excel reports a spill error, clear cells blocking the results. Excel versions before 2021 do not have the FILTER function; use the built-in filter or another method available in that version.

Common date-filter problems

The menu shows years and months, but the range is wrong. Excel may group recognized dates into a hierarchy in the dropdown. Expand the relevant year or month to select specific entries, or choose the Between command under Date Filters for a precise interval. Confirm that you opened the dropdown for the intended date field.

No rows appear even though dates seem to match. The entries may be text, the date order may have been interpreted differently during import, or the selected range may exclude the rows you expect. Test a cell’s value and inspect the source data. If the list contains text dates, convert them carefully using a method appropriate to their format rather than relying on display formatting alone.

Some dates within the last day are missing. Check whether the source contains times hidden by the cell format. A visible date can represent a timestamp. Use an end condition that includes times through the entire final day, such as the formula’s less-than-next-day comparison, or remove time values only if that is appropriate for the data.

New records are not included. If the filtered range was selected manually, rows added beneath it may fall outside the original range. Convert the list to a table so it can expand, or update the filtered range. For a PivotTable, refresh it after changing the source data.

The results appear out of order. Filtering hides nonmatching rows; it does not sort the remaining records. Use the date column’s dropdown and choose an ascending or descending sort if you also need chronological order. A text date column may sort alphabetically instead of by date, so correct the data type first.

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 clear filters across the active list, use Data > Sort & Filter > Clear. The exact ribbon grouping can vary slightly with window size, but the Clear command is on the Data tab. Clearing a filter makes hidden rows visible again; it does not erase the rows or their contents.

To change the period, reopen the date dropdown and edit the Between conditions. You do not need to turn filtering off and rebuild the list. If you are using a formula-based result, edit the start or end date in the criteria cells instead. For repeated reporting, keeping the date criteria in clearly labeled cells makes it easier to see which period the output represents.

Frequently Asked Questions

Can I filter Excel dates between two dates?
Yes. Open the date column dropdown, choose Date Filters > Between, enter the start and end dates, and select OK. Use actual Excel date values so the comparisons work correctly.

Does Excel include the start and end dates in a Between filter?
The standard Between date filter includes the boundary dates. If the cells contain timestamps as well as dates, check whether times on the final day are included; the displayed date may hide a time value.

Why does Excel treat my dates as text?
Imported or inconsistently formatted values may not have been recognized as dates, even if they look like dates on screen. Changing the number format alone does not convert text. Check the source format and convert the values using a method that preserves the intended month-and-day order.

Can I filter by month without entering two dates?
Yes. Open the date dropdown and use the date hierarchy or a relative period such as This Month when it appears. For a fixed month, Between with the first and last calendar dates is explicit and easy to verify.

Can I filter a date range with a formula?
Yes. In Excel 2021 or Microsoft 365, FILTER can return matching rows to a separate area. Use the built-in dropdown instead if you only need to hide nonmatching rows in the existing list or if your Excel version does not support FILTER.

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.