To filter Excel by date, select a cell in your data, choose Data > Filter, open the arrow in the date column’s header, and select a date option such as Date Filters > Between. You can narrow a list to a particular day, month, year, or custom range without deleting any rows.
Apply a basic date filter
These steps apply to Excel for Microsoft 365 on Windows. Your data should have a single header row, with dates in one column and one record per row. For example, an order list might have columns named Order Date, Customer, and Amount.
- Click a cell inside the data range. If your dataset has blank rows or columns splitting it into sections, select the full range instead.
- Go to Data > Filter. Excel adds a drop-down arrow to each header cell. On Windows, Ctrl+Shift+L is a shortcut for toggling filters on and off.
- Open the arrow in the date column’s header. Choose a date, month, or year from the checklist, or open Date Filters for comparison options.
- Select the dates you want to keep, then choose OK if the menu presents an OK button. Excel hides rows that do not match; it does not remove them.
To show the entire dataset again, use the date column’s arrow and choose Clear Filter From [column name], or choose Data > Clear. Clearing a filter restores hidden rows but does not change the underlying date values. On Mac, the ribbon’s Data > Filter controls are available as well; if a keyboard shortcut differs with your Excel or keyboard settings, use the ribbon command. Excel for the web also supports column filter menus, though some dialog details can differ.
Choose a date, month, or year
When Excel recognizes the column as dates, its filter menu can show a date hierarchy. Expand or collapse years and months to select individual dates or a whole period. For example, selecting 2025 and then March keeps records from March 2025, while selecting a particular day keeps records for that day. The checklist is useful for exploring known dates, but it can be awkward when a list covers many years or when you need a precise start and end boundary.
For a relative period, open Date Filters. Depending on the data and Excel version, the menu offers choices such as Today, Yesterday, This Week, Last Month, or This Year, along with comparison choices such as Before, After, and Between. The relative choices are convenient for work queues—for example, showing orders from this month—without manually selecting every date. They use the current date as their reference, so reapply the filter if you need to refresh results after the calendar period changes.
Choosing a year or month in the checklist is not the same as sorting. A filter hides nonmatching records and keeps the original row order. To arrange visible records chronologically, use the date column’s menu to sort oldest to newest or newest to oldest. Sorting changes row order, not which records exist.
Filter a custom date range
To show dates between two boundaries, open the date column’s arrow, choose Date Filters > Between, and enter the start and end dates in the dialog. For example, entering April 1, 2026 and April 30, 2026 keeps April records in a date-only column. Use Before or After when you need a one-sided cutoff, such as invoices dated before January 1, 2026.
Check whether the endpoints should be included. Between is suited to a range with a start and end date, while Before and After express a boundary comparison. For a report described as “from Monday through Friday,” enter both Monday and Friday as the range endpoints. If the task is “after Friday,” do not assume that means “Friday onward”; use the comparison that matches the intended cutoff.
Type dates in a format Excel recognizes in your regional settings. If the dialog interprets 04/05/2026 as April 5 in one setting and May 4 in another, use an unambiguous entry format supported by your locale, or pick dates from the calendar control where available. For repeat reports, writing the intended date range in nearby worksheet cells can also make the criteria easier to audit.
Prepare the data so Excel recognizes dates
A value that looks like a date may actually be text. Excel filters text differently: instead of a date hierarchy and Date Filters options, you may see ordinary text choices, or entries may appear in an unexpected order. Dates imported from a website, CSV file, database, or another locale are common sources of this problem.
Excel stores real dates as serial values and displays them using a number format. Changing a cell’s appearance to a date format does not necessarily convert text into a real date. A quick clue is that a genuine date generally sorts chronologically, while text dates can sort alphabetically or remain grouped in ways that seem inconsistent. Confirm the source and regional date order before converting values; guessing can swap day and month.
For a text column that has a consistent, known date order, you can use Data > Text to Columns. Select the column, start the wizard, advance to the step with Column data format, choose Date, select the source order such as MDY or DMY, and finish. Make a copy of the data first, especially if the original text must be preserved. The wizard can reinterpret values, and the correct choice depends on how the source wrote the dates.
Another approach is to convert imported text in a separate helper column, then check a sample of the results before using that column to filter. Do not rely on a display format alone as proof of conversion. Once Excel recognizes actual date values, format them consistently with Home > Number Format if needed, then reapply the filter.
Handle timestamps and time values
A date-time value includes both a calendar date and a time. For instance, 6/10/2026 3:30 PM is later than 6/10/2026 12:00 AM even though both values fall on June 10. This matters when filtering exports such as website activity, deliveries, or transaction logs. A date-only display format can hide the time portion without removing it.
If you need all events on an end date, make sure the filter includes the whole day rather than only values up to midnight at its start. One robust method is a helper column that tests whether each timestamp falls within the requested interval. With timestamps in A2:A100, a start date in D1, and an end date in D2, enter the following in E2 and fill it down; the result is TRUE for timestamps on or after the start and before the day after the end:
=AND(A2>=$D$1,A2<$D$2+1)
Then filter the helper column to TRUE. D1 and D2 need to contain real Excel dates, and the timestamp values in column A must be real date-time values. The less-than boundary includes times throughout the end date while excluding midnight on the following day. This approach is also useful when a report’s intended time window is more exact than a simple calendar-date selection.
Filter an Excel table or a regular range
AutoFilter works on both a normal range and an Excel table. A table is often easier to manage for a list that grows: click inside the data and choose Insert > Table, confirm that the range includes the headers, and leave My table has headers selected when appropriate. Tables provide header filter arrows and generally extend their structure as new rows are added. A regular range is fine for a fixed dataset, but new rows added outside the filtered range may not be included automatically.
Keep each column consistent: put one type of information in each column, avoid repeated header rows inside the data, and do not merge cells in the list. Blank rows can cause Excel to interpret only part of a region as the dataset. If a filter arrow is missing from the date header, click in the data and check whether the full intended range was selected when filtering was turned on.
Common date-filter problems
- Date Filters is missing. Excel may be treating the entries as text, or the selected column may contain mixed types. Check several cells and convert the source values consistently.
- Some expected rows disappear. Another column may have its own active filter. Clear filters on the other columns, too, and confirm that the selected dates include the intended endpoints.
- Dates appear in a strange order. Mixed text and date values, or day/month interpretation differences, can disrupt sorting. Verify the source format and convert a copy before changing the original data.
- The filter arrow is missing. Turn on Data > Filter again, and check that the data has one clear header row and no blank separator that splits the range.
- A date-only filter seems to miss events on the last day. The cells may contain times. Use the calendar-date selection carefully or add a helper test with an exclusive next-day boundary.
- Results do not change after updating the source. Reopen the filter menu and reapply or clear and set the criteria again. Also confirm that new records are inside the filtered range or have been added to the table.
Use a formula when you need a separate filtered view
Filtering a source table hides rows in place. If you want a separate, automatically updating result list, Excel’s FILTER function is an alternative in Microsoft 365 and Excel 2021 or later. With dates in A2:A100, the records to return in B2:D100, a real start date in F1, and a real end date in G1, enter this formula in an empty area:
=FILTER(B2:D100,(A2:A100>=F1)*(A2:A100<G1+1),"No matching rows")
The formula returns the rows whose date in column A is on or after F1 and before the day after G1, so an end date with timestamps is included through the end of that day. The result spills into neighboring cells; leave room for it, and do not place it inside the source data. Unlike an AutoFilter, this creates a displayed result rather than hiding nonmatching source rows. If your Excel version does not support FILTER, use the regular column filter or a helper column instead.
Frequently Asked Questions
How do I filter Excel to show only one date?
Turn on Data > Filter, open the arrow in the date header, and select the date from the date checklist. If you do not see dates organized by year or month, Excel may have stored the entries as text.
Can Excel filter dates by month without filtering by year?
You can select a month within a year in the date hierarchy. If you need the same month across several years, use Date Filters or a helper column to specify the intended month condition; selecting March under one year will not include March in other years.
How do I filter between two dates, including both dates?
Choose Date Filters > Between and enter the start and end dates. If your cells include times, test the results carefully; a helper condition using the day after the end date as an exclusive boundary reliably includes all times on the end date.
Why does Excel show text filters instead of date filters?
The column may contain text strings rather than Excel date values, or a mixture of text and dates. Convert the entries using the source’s actual date order, then reopen the filter menu.
Does filtering by date delete rows?
No. A filter hides rows that do not match the criteria. Clear the filter to show them again. Deleting visible rows is a separate action and should not be confused with filtering.
Choose the simplest method that fits
For a quick look at a known day or month, use the date checklist. For a reporting period, use Date Filters > Between. For timestamps, imported text, or a reusable output list, first validate the values and consider a helper column or FILTER formula. In every case, filtering changes what is visible—not the underlying records—so you can clear the criteria when you need the full dataset again.
Related
- Excel Shortcut to Select an Entire Column
- Excel Shortcut to Select to the End of a Column Explained
- Export to CSV vs Excel: Which Format Should You Choose?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Filter by Number in Excel: A Step-by-Step GuideTo filter by number in Excel, select a cell in your data, choose Data > Filter, open the…
- Excel Link to Named Range: Formulas and MethodsTo create a clickable link to a named range in Excel for Microsoft 365 on Windows, use the…
- Sort in Excel and Move Entire Rows Without Splitting DataTo sort in Excel and move entire rows together, select the full data range, then choose Data >…
- LARGE and SMALL Excel Formulas: Find Ranked ValuesUse Excel’s LARGE and SMALL functions to return the value at a chosen rank in a set of…
- Sort Excel Rows by Column Value: A Practical GuideTo sort rows in Excel by a column value, click a cell in the data, then choose Data…
- Excel VLOOKUP Yes or No: How to Return a Match ResultYes. In Excel for Microsoft 365, you can make VLOOKUP return “Yes” or “No” by wrapping an exact-match…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.