To filter Excel dates between two limits, open the filter arrow in the date column, choose Date Filters > Between, enter the start and end dates, and confirm. Excel includes both boundary dates in this filter; if your column contains times as well as dates, use the timestamp guidance below to avoid excluding records from the final day.
Quick steps for filtering between dates
These steps apply to Excel for Microsoft 365 on Windows. Your data should have a single header row and one record per row, with a date column whose cells contain actual Excel dates rather than date-looking text.
- Click a cell in the data range. If the range is not already a table, select a cell within it and choose Data > Filter. You can also use Ctrl+Shift+L on Windows to turn AutoFilter on or off.
- Open the arrow in the date column’s header. If the menu shows a calendar hierarchy, expand the year, month, or day levels as needed, or open Date Filters.
- Choose Between. In the custom filter dialog, set the first condition to “is after or equal to” and enter the start date; set the second condition to “is before or equal to” and enter the end date. The dialog may label this simply as a date range.
- Make sure the conditions are joined with And, then select OK. The visible rows should have dates on or after the start and on or before the end.
For example, a start date of 1 March 2026 and an end date of 31 March 2026 selects March records, including entries dated March 1 and March 31. The year matters: entering March 2025 instead of March 2026 selects a different period.
What Excel means by a date
Excel stores most dates as serial numbers, with the displayed date format controlling how those numbers look in a cell. A value that displays as 3/1/2026 can therefore be compared chronologically if Excel recognizes it as a date. A text string that merely looks like 3/1/2026 may not behave the same way.
This distinction explains many failed filters. If Excel sees genuine dates, it can offer date-specific options such as year, quarter, month, and day, and it can sort dates in chronological order. If the entries are text, the filter may instead offer text options, sort them alphabetically, or leave some expected rows out of a range.
Date interpretation can also depend on regional settings. For example, 04/05/2026 can mean April 5 or May 4 depending on the convention used when it was entered or imported. When dates are ambiguous, verify the source and use an unambiguous entry such as a date entered through a calendar control or a format that clearly identifies the month.
Using the date hierarchy or a custom range
Excel may group recognized dates in the filter menu into a hierarchy, commonly showing years, months, and days. This is useful when you want a whole month or year: expand the relevant year and month and select the dates you need. For an exact start-and-end range, use the Date Filters > Between option rather than selecting many individual calendar checkboxes.
The Between filter is helpful for periods that do not line up with a calendar month, such as 10 March through 22 April. It is also a clear choice for a rolling reporting period once you know the two dates. The two conditions should use And, because a qualifying value must satisfy both the lower and upper limits. Or would include values meeting either condition, potentially bringing in dates outside the intended range.
If you do not see Date Filters, first check whether the cells in that column are recognized as dates and whether the filter is on the correct header. A mixed column containing dates, text, blanks, and error values can produce a less intuitive menu. Cleaning the column before filtering is often more effective than trying different filter options.
Filter dates with time values
A cell can contain a date and a time even when its number format displays only the date. For instance, a value may represent 31 March 2026 at 4:30 p.m. A filter whose upper limit is the date 31 March at midnight can exclude that later timestamp, depending on the condition and how the value is stored. This is a common reason the final day seems to disappear.
If your data includes timestamps, a robust range means “at or after the start date, but before the day after the end date.” In a worksheet formula, that upper limit is written as the end date plus one day with a less-than comparison. The filter dialog may not make this boundary adjustment obvious, so a helper column or a formula-based result can be easier to audit for timestamp-heavy data.
Another option is to create a separate date-only helper column from the timestamp, then filter that column. Keep the original timestamp if the time of day is important for analysis; do not replace it with a date-only value unless losing the time component is intended.
Use a formula for a reusable date range
A formula can return matching rows to a separate area and update when you change the two boundary cells. In Microsoft 365, the FILTER function returns a dynamic array that spills into nearby cells. It is useful when you want the source data to stay visible or need a report that responds to new date limits.
With complete records in A2:D100, dates or timestamps in B2:B100, the start date in F1, and the end date in G1, use:
=FILTER(A2:D100,(B2:B100>=F1)*(B2:B100<G1+1),"No matching rows")
The multiplication combines the two tests as AND: the date must be at least F1 and earlier than the day after G1. If F1 is 3/1/2026 and G1 is 3/31/2026, the formula returns rows from March 1 through the end of March, including timestamps on March 31. If no rows match, it displays “No matching rows.” FILTER is available in Microsoft 365 and Excel 2021 or later, but not in older perpetual versions such as Excel 2019.
For date-only values, the same formula works and safely includes the end date. If you specifically want a filter that excludes all times after midnight on the end date, use an inclusive upper comparison instead, but that is rarely what people intend when selecting a whole final day. Make sure F1 and G1 are real dates and that the start is not later than the end.
Fix dates that will not filter correctly
When the results look wrong, check the data before changing the filter conditions. A filter acts on the values Excel has, not only on what the cells appear to show.
- Check whether the values are dates: change a sample cell’s number format temporarily to General. A recognized date normally displays as a number; text remains text. This is a useful clue, though imported data can require further inspection.
- Look for inconsistent entries: some rows may be dates while others are text, or may include leading spaces or apostrophes. Convert the text consistently before relying on date comparisons.
- Check for hidden time components: two cells can both display the same date while one contains a time. Widen the date range or use the before-next-day method when the last day is missing.
- Confirm the full range is filtered: blank rows or a second header row can cause Excel to treat part of a list as a separate block. Use a contiguous data range with one header row.
- Clear other filters: an active filter in another column may hide rows that meet the date condition. Choose Data > Clear to clear filters from the range, then reapply the date filter.
- Verify the year and regional order: confirm the actual year in the criteria and whether an entered numeric date was interpreted month-first or day-first.
After converting imported text dates, reapply or refresh the filter if the menu does not update. In Excel, formatting a text value to look like a date does not by itself convert the underlying text into a date value.
Tables, Excel for Mac, and Excel for the web
For data you will keep extending, converting the range to an Excel table with Insert > Table is often convenient. Tables provide header filter arrows and generally extend as rows are added, reducing the risk that new records sit outside the filtered range. Filtering a table hides nonmatching rows; it does not delete them.
Excel for Mac has the same basic date-filter approach through the header arrow and the Date Filters options. The Windows shortcut Ctrl+Shift+L is not the Mac shortcut; current Excel for Mac commonly uses Command+Shift+F to toggle filters. If a keyboard shortcut differs in your setup, use the ribbon’s Data > Filter command. Excel for the web also supports filtering from column headers, though the menu layout can differ slightly from the desktop app.
Filtering is not the same as deleting or extracting records. To copy only matching rows, apply the filter and copy the visible records, or use a dynamic-array formula in a separate area. Check the selected range before copying, especially if the data has hidden columns or other active filters.
Frequently Asked Questions
Can Excel filter dates between two dates inclusively?
Yes. Use the Between date filter and set the conditions to on or after the start and on or before the end. For date-time values, use a boundary before the day after the end date so that later times on the final day are included.
Why does Excel show months or years instead of individual dates?
Excel often groups recognized dates into a year-month-day hierarchy in the filter menu. Expand the levels to select individual dates, or choose Date Filters > Between to enter two limits directly.
Why is Date Filters missing from the dropdown?
Excel may not recognize the column as dates, or the selected dropdown may belong to a different column. Check the underlying values, confirm the header, and convert date-like text into real dates before trying again.
Can I filter a date range that crosses two years?
Yes. Enter the complete start and end dates, including the correct years. A range such as 15 December 2025 through 10 January 2026 works normally; avoid entering only month and day when the year affects the results.
Does filtering delete rows that fall outside the range?
No. AutoFilter temporarily hides rows that do not meet the criteria. Clear the filter to show them again. Deleting visible or hidden rows is a separate action and should not be confused with filtering.
Related
- Excel Dependent Drop-Down List: 3 Levels
- Excel Dependent Drop-Down Lists with Dynamic Ranges
- Excel Dependent Drop-Down Lists in Tables
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- SUMIFS in Excel: Count or Sum Matching Values?SUMIFS in Excel adds numeric values that meet one or more conditions; it does not normally count matching…
- Excel SUMPRODUCT Shortcut: Formula, Uses, and ExamplesExcel has no dedicated keyboard shortcut for SUMPRODUCT: enter the formula in a cell and press Enter. For…
- Find and Replace Formula in Excel: SUBSTITUTE or REPLACEIn Excel, use SUBSTITUTE to replace matching text inside a cell, or REPLACE to replace characters at a…
- Excel Date Subtraction: Formulas, Days, and WorkdaysTo subtract one date from another in Excel, subtract the earlier date cell from the later one: if…
- Excel Insert Image from URL: Formula, Steps, and FixesTo insert an image from a URL in Microsoft Excel for Microsoft 365, put the direct image address…
- Excel MAX IF Formula: Find the Largest Matching ValueTo find the largest value in Excel that meets a condition, use MAXIFS. For example, with categories in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.