To filter data between two dates in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the arrow in the date column, then choose Date Filters > Between. Enter the start and end dates and confirm; Excel displays rows whose dates fall within that range.
What a date filter does
Excel stores real dates as serial numbers, so a date filter can compare dates in a column rather than merely matching the way they look on screen. For example, a cell displayed as 5/10/2026 can be formatted as May 10, 2026 while still representing the same underlying date. A filter for May 10 through May 12 can therefore show records on those dates, regardless of the display format.
The date column should contain one date per row, with a clear header such as Order Date. Each row should represent a record, and the other columns should contain details such as customer, product, or amount. A header row and consistent columns make Excel more likely to recognize the range as a coherent list.
“Between” normally means the boundary dates are included: a record dated on the start date or end date remains visible. That is useful for reporting a calendar period such as a week or month. If your data includes times as well as dates, however, the end-date boundary needs extra care; see the timestamp section below.
Filter a date column with the ribbon
- Click a cell inside the data range. Check that the first row contains column headings and that there are no completely blank rows or columns splitting the list.
- Choose Data > Filter. Excel adds a drop-down arrow to each heading. On Windows, Ctrl+Shift+L toggles filtering on or off. In Excel for Mac, use Data > Filter; shortcuts can differ with the keyboard and settings.
- Open the arrow on the date heading, point to Date Filters, and choose Between. The menu may also offer options such as Before, After, or a particular period.
- Set the first condition to the start date and the second to the end date. Confirm that the conditions are joined with “And,” so a row must satisfy both limits, then choose OK.
For example, to show orders from May 1 through May 31, 2026, use May 1, 2026 as the lower boundary and May 31, 2026 as the upper boundary. Excel hides rows outside the interval but does not delete them. The filter arrow usually shows a filter indicator when a column has an active condition. To restore all rows, reopen that arrow and choose Clear Filter From the date field, or use Data > Clear to clear filters from the range.
How Excel’s date filter behaves
A filter hides nonmatching rows; it does not rearrange the source data unless you separately sort it. You can filter more than one column at once. For example, filter Order Date between two dates and then filter Region to West. Excel then shows records that meet both the date condition and the region condition.
Date Filters is a contextual menu: Excel needs to recognize the column values as dates. When the column contains valid dates, the menu can group options into years, quarters, and months, depending on the data. If the values are stored as text, you may instead see ordinary text-filter choices, or a date condition may fail to include records as expected.
Filters are also different from deleting or extracting records. Hidden rows remain in the worksheet and can be shown again by clearing the condition. If you copy filtered data, check whether you want only visible cells; copying a filtered range can behave differently from copying an unfiltered block, especially when hidden rows are involved.
Use a formula for a refreshable result
A formula can return matching rows in a separate area rather than hiding rows in the source list. This is convenient for a report that should update when the start date, end date, or source data changes. The FILTER function is available in Microsoft 365 and Excel 2021 or later; its results spill into neighboring cells, so keep the output area clear.
Assume the source records occupy A1:D100, with headers in row 1 and dates in C2:C100; put the start date in F1 and the end date in G1. Enter this formula in a blank cell outside the source data:
=FILTER(A2:D100,(C2:C100>=F1)*(C2:C100<=G1),"No matching rows")
The two comparisons create true-or-false tests for each row. Multiplying the tests works like AND: both the lower and upper conditions must be true for a row to appear. With F1 set to May 1, 2026 and G1 to May 31, 2026, this returns the source rows dated within May, including both May 1 and May 31. If nothing matches, the formula displays “No matching rows.” The formula returns data columns A through D but not the header, so add or copy the headings separately if the result needs them.
Use real Excel dates in F1 and G1, not text that only resembles a date. Format those cells as dates if you want them to be easy to read. If your Excel installation uses semicolons rather than commas as formula separators because of regional settings, Excel may require that local separator when you enter a formula.
Include all times on the end date
A date-time value includes a fractional part for the time. For instance, a record at 3:00 p.m. on May 31 is later than the value for midnight at the start of May 31. A test that asks whether a timestamp is less than or equal to the end date at midnight can therefore omit most records from the final day.
For a source range A1:D100 with timestamps in C2:C100, and a start date in F1 and end date in G1, use this variation in a blank cell:
=FILTER(A2:D100,(C2:C100>=F1)*(C2:C100<G1+1),"No matching rows")
This includes timestamps from the start of the first day up to, but not including, midnight after the end date. For a May 1 to May 31 range, it includes a May 31 record at 11:59 p.m. but excludes a June 1 record. This approach is often clearer for timestamps than trying to specify the very last possible time of a day. In the ordinary filter menu, inspect the results when timestamps are present; a formula with the exclusive next-day limit makes the intended boundary explicit.
Prepare the data for reliable filtering
Before filtering a large list, check the structure and date values. These steps prevent many apparent filter errors:
- Use one header row with a distinct label for each column, and avoid merged cells in the data area.
- Keep dates in one column and records in adjacent columns. Do not insert title text or blank rows inside the list.
- Enter actual dates consistently. A value imported from a website or CSV may be text even when it looks like a date.
- Set the start and end criteria in an unambiguous format, such as 15-May-2026, if regional date conventions could confuse month and day.
- Consider converting the range to an Excel table with Insert > Table. Tables include filter arrows by default and usually expand when new rows are added.
A table is especially useful when new records arrive regularly: its filter controls and formatting extend as the table grows. A filter applied to a plain range may not include rows added below the original range, so check the selected range before relying on a recurring report. Neither a table nor a filter repairs malformed dates; imported text still needs to be converted to genuine date values.
Troubleshoot missing or unexpected rows
If Date Filters is absent or the result looks wrong, first determine whether Excel recognizes the entries as dates. Select a suspicious cell and change its number format temporarily. If changing the format does not affect its appearance, the value may be text. Another clue is alignment: dates stored as text often align differently from numeric dates, although alignment alone is not conclusive because formatting can override it.
Text dates can be converted using Excel’s import and conversion tools, but the correct method depends on their original pattern and regional settings. For a consistent column, try selecting it and using Data > Text to Columns, then choose the appropriate date order in the conversion options. Make a copy first if the data is important, and inspect the converted values before replacing the original column. A string such as 04/05/2026 is ambiguous: it can mean April 5 or May 4 depending on the convention used when it was created.
Also check for these common causes:
- Wrong date order: The entered boundary may be interpreted as day/month rather than month/day, or vice versa. Use a long date format to verify it.
- Time values: A timestamp can fall outside a midnight end boundary even though its calendar date appears to be the end date.
- Unexpected blanks: Blank date cells do not satisfy a normal date interval and may be hidden by the filter.
- Range not expanded: New rows may sit below a plain filtered range. Clear the filter, include the added rows, and apply the filter again, or use a table.
- Other active filters: A second column may be hiding rows that meet the date condition. Clear other column filters to isolate the cause.
Choose between the filter menu and a formula
Use the built-in filter when you want to inspect or temporarily narrow the existing list. It is quick, requires no formula, and lets you combine a date range with other column conditions. Use FILTER when you need a separate, automatically updating extract for a dashboard, review sheet, or report. A formula also makes the boundary logic visible, which matters when timestamps or repeatable reporting rules are involved.
For a one-time selection, the menu is usually simpler. For a reusable output, a formula is more convenient, but it depends on a modern Excel version and needs space to spill. If your version does not support FILTER, use the built-in filter or an Advanced Filter setup instead. Regardless of method, confirm that the source dates are real date values and that the boundary dates match the reporting period you intend.
Frequently Asked Questions
Does Excel include the start and end dates when I choose Between?
Yes, the Between condition is intended to include both boundary dates. If the column contains times as well as dates, verify end-date results; a formula using less than the day after the end date avoids excluding later times on that date.
Why can’t I see Date Filters in the drop-down?
Excel may not recognize the column as dates, particularly if its values were imported as text. Check the underlying values and convert text dates to real dates. Also make sure you opened the arrow for the date column, rather than a different field.
Can I filter by month without entering two exact dates?
Yes. Open the date column’s arrow and look under Date Filters for period options such as All Dates in the Period, then choose the month or other available period. The exact choices depend on the date values in the column.
Will filtering delete rows outside my date range?
No. Filtering hides rows that do not match; it does not delete them. Clear the date filter to show the full list again. Avoid deleting rows unless that is specifically what you intend.
Can I filter a date range in Excel for the web or Mac?
Excel for the web and Excel for Mac provide filter controls, though the layout can differ from Windows. Look for the date-column drop-down and its date-filter options; on Mac, the ribbon path is Data > Filter. The FILTER formula is also available in supported Microsoft 365 versions.
Related
- Excel Template for a Social Media Calendar
- Excel Job List Template: Track Applications and Follow-Ups
- Excel To-Do List Templates: How to Choose and Use One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Conditional Formatting: Create a Formula RuleTo create a formula-based conditional formatting rule in Excel for Microsoft 365 on Windows, select the cells to…
- VLOOKUP in Excel for Multiple Columns: Methods and TipsYes. In Excel for Microsoft 365, VLOOKUP can return values from multiple columns either by copying one formula…
- How to Divide in Excel: Formulas and the QUOTIENT FunctionTo divide values in Excel, enter a formula with the forward slash operator, such as =A2/B2. Excel does…
- Power Query XLOOKUP: Matching Data in Excel ExplainedPower Query does not have an XLOOKUP function. To match rows from two tables in Power Query, use…
- Excel WORKDAY Formula: Does It Exclude Weekends?Yes. In Microsoft Excel for Microsoft 365 on Windows, WORKDAY excludes Saturday and Sunday by default when it…
- Excel COUNTIF for Dates Between a RangeTo count dates between two boundaries in Excel, use COUNTIFS, which applies both a start-date and an end-date…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.