To filter an Excel sheet by date in Microsoft Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the arrow in the date column’s header, and select a date option or Date Filters > Between to enter a range. Filtering hides rows that do not match; it does not delete them. Before you begin, make sure your data has a header row and that Excel recognizes the entries in the date column as dates.
What You’ll Need
- An Excel workbook with a column of dates and a clear header, such as Order Date or Due Date.
- A continuous data range with one header row and no completely blank rows or columns splitting the records.
- The date range or period you want to show. If your dates include times, note that too, since a time value can affect the range’s end boundary.
Step-by-Step
- Check the layout of your records. Each row should represent one record, and each column should contain one type of information. Put a unique, descriptive label at the top of the date column. Avoid merged header cells, duplicate header names, and blank rows inside the list; these can make Excel identify the filter range incorrectly. If the worksheet has notes or totals directly beside the records, move them away from the data first.
- Confirm that the dates are real Excel dates. Click a date cell and look at the formula bar. A valid date is stored by Excel as a number, even if it is displayed in a format such as 03-Nov-2026. Changing the cell’s number format can alter how a real date looks, but it will not turn text into a date. If dates are left-aligned while other dates are right-aligned, or they do not respond to date sorting, some may be stored as text. Fix those entries before filtering; the troubleshooting section explains what to check.
- Turn on the filter arrows. Click any cell inside the data range, then choose Data > Filter on the ribbon. Excel usually detects the full block of adjacent data and adds a drop-down arrow to each header. You can also select the full range first if Excel does not detect it correctly. On Windows, Ctrl+Shift+L toggles AutoFilter. On Mac or Excel for the web, use Data > Filter if that shortcut does not work or is assigned differently.
- Open the filter for the date column. Click the arrow in the header of the column containing dates, not the arrow in a different field such as Customer or Status. Excel may show a list of date values grouped into years, months, and days. You can expand or collapse the groups with the small controls beside them. If Excel shows ordinary text options rather than date options, check that the column contains genuine dates and that the selection includes the correct header.
- Choose a quick date period when it fits. In the date column menu, point to or open Date Filters. Depending on the available options and Excel’s display, you can choose a relative period such as Today, This Week, This Month, or Last Month, or select a specific period from the date hierarchy. Relative options are useful for rolling reports because, for example, This Month changes as the calendar changes. A selection of fixed dates from the hierarchy, by contrast, stays tied to those specific dates.
- Set a custom start and end date. For a range, open the date column arrow, choose Date Filters > Between, and enter the beginning and ending dates in the Custom AutoFilter dialog. For example, to show records from April 1 through April 30, enter 4/1/2026 as the first date and 4/30/2026 as the second, using a date format Excel recognizes on your computer. The Between criteria normally include both boundary dates. Check the dialog’s comparison choices and values before applying them, especially if you change the default conditions.
- Apply the filter and inspect the results. Select OK in the dialog. Excel hides rows outside the selected range and leaves matching records visible. Check several visible dates, including the first and last dates you expected, and look at the row numbers: gaps indicate that some rows are hidden by the filter. A status bar count or a filtered-row count can help you confirm the result, but do not assume that a displayed total represents every row in the worksheet.
- Adjust or clear the filter when needed. Reopen the same date-column arrow to change the conditions, choose a different period, or select all dates again. To clear the filter for just that column, use the clear option in its menu. To remove filters from the range, choose Data > Filter again; this turns off the arrows but does not restore rows hidden by other manual hiding. To show every record while keeping the arrows, use Data > Clear or clear each active column filter.
- Consider converting the range to a table for ongoing work. Click inside the records and choose Insert > Table, confirm the selected range, and make sure My table has headers is checked. Tables include filter arrows and usually expand when you add new records directly beneath them. This is helpful for recurring lists, but still check that new entries are genuine dates and are included in the intended table.
Common Mistakes
Filtering dates that are actually text: A value can look like a date without being stored as one. Text dates may sort alphabetically, appear in a separate section of the filter menu, or fail to match a date condition. Convert or re-enter them as dates before relying on the results.
Using a header row Excel did not recognize: If the header is blank, duplicated, or outside the selected range, filter arrows can appear on the wrong row or not appear at all. Keep one clear header row and include it when selecting the records.
Filtering only part of a dataset: If you select just the date column, the other fields may not stay connected to the correct records. Apply the filter to the whole contiguous table or range so a hidden record’s name, amount, and date all hide together.
Confusing filtering with deleting or sorting: Filtering temporarily hides nonmatching rows; it does not remove them. Sorting changes the order of records. If you copy or total data while a filter is active, confirm whether the operation includes hidden rows, since behavior varies by action.
Forgetting other active filters: A date may seem to be missing because another column is also filtered. Review the arrows for filter indicators and clear other criteria before deciding that the date itself is absent.
Tips
- Use a table for lists that grow. A formatted Excel table is easier to filter and extend than a loosely selected block. Give each column a single, useful header, such as Invoice Date rather than Date 1.
- Use the hierarchy for a whole calendar period. Selecting a month or year in the grouped date list can be quicker than checking many individual days. Expand the year or month if you need only particular dates within it.
- Use Between for fixed reporting periods. This is clearer than selecting dates one by one when you need a quarter, a billing window, or a particular start and end date. Record the chosen boundaries in your report notes if others need to reproduce the filter.
- Be careful with dates that include times. A cell displayed as 4/30/2026 may actually contain 4/30/2026 at 3:45 PM. If a custom filter with an end date at midnight leaves out later times on that day, set the upper condition to is before the day after your intended end date. For April 1 through April 30, for example, use a start condition of on or after April 1 and an upper condition of before May 1. This includes every time on April 30 while excluding May 1.
- Keep a visible note of the criteria. A filtered worksheet can look like a complete list even though many rows are hidden. Add a note outside the data range or include the date boundaries in a report title so readers understand what they are viewing.
- Know where the commands may differ. The Windows instructions use the Microsoft 365 ribbon. Excel for Mac and Excel for the web also provide filtering from the Data tab, though ribbon layout, dialog appearance, and shortcut behavior can differ by platform and update. If a named option is not immediately visible, open the date-column menu and look for its date-filter submenu.
Troubleshooting
Date Filters is missing, or the menu shows text filters. First click a cell in the correct date column and check a few entries. Select a cell that should be a date, change its number format temporarily to a date format, and see whether its display changes. If it remains unchanged or behaves like text when sorted, convert the values. One common approach is to use Data > Text to Columns, keep the appropriate delimiter settings, and choose the correct date order under the column data format before finishing. Make a copy of the data first if the column contains mixed formats, because conversion can change values.
Dates are interpreted as the wrong month or day. Excel reads entries such as 04/05/2026 according to regional date settings, so that value may mean April 5 or May 4. Use an unambiguous entry, such as 5-Apr-2026, or check the computer’s regional date format. When importing a file, specify the source date order rather than assuming Excel will infer it correctly.
Expected rows are missing at the end of the range. Check whether the records include times, then adjust the upper boundary as described in Tips. Also clear any other column filters, and verify that the end date was entered in the format Excel expects. If the result is still unexpected, temporarily clear all filters and search the date column for the missing record.
New rows do not appear after filtering. If the data is a normal range, newly added rows may sit outside the filtered area. Turn off the filter, select the expanded range, and turn it back on, or convert the records to a table so added rows can join it. Check for a blank row that may have split the original range.
The arrows do not show, or filtering affects the wrong cells. Select a cell in the data and choose Data > Filter again. Confirm that the list has one header row and no merged cells, and inspect the selected range. If the worksheet is protected, filtering may be restricted by its protection settings; the workbook owner may need to allow filtering or unprotect the sheet.
Frequently Asked Questions
Can I filter Excel to show only one date?
Yes. Open the arrow on the date column and select that date in the grouped list, or use Date Filters and choose the option for an exact date if it is available. Confirm that no other column filter is hiding matching rows.
Can I filter by month without selecting every day?
Usually. Open the date list and select the month in its year-and-month hierarchy, or use a matching period under Date Filters. If the dates are grouped only as text or the hierarchy is not available, check that Excel recognizes them as dates.
Does filtering change or delete my data?
No. A filter hides rows that do not meet the criteria, and you can reveal them by clearing the filter. It does not permanently remove those rows. Deleting visible rows is a separate action, so check that you are not selecting and deleting records by mistake.
Why does a date appear in the sheet but not in the filter list?
The value may be text, outside the filtered range, or hidden by another filter. It can also be a date-time value whose displayed date conceals its time. Check the cell’s stored value, clear other filters, and make sure the data range includes that row.
Can I filter by dates in Excel for Mac or the web?
Yes. The same basic approach applies: select the data, open Data > Filter, and use the date column’s arrow. The ribbon and dialog may look different from Windows, and some shortcuts vary, so use the menu paths if a keyboard shortcut does not work.
Related
- How to Edit Custom Number Formats in Excel Step by Step
- How to Edit Border Color in Excel: Step-by-Step Guide
- How to Duplicate a Text Box in Excel Without Rebuilding It
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Cell Contains String? Find Text With a FormulaTo check whether a cell contains a particular string of text, use =ISNUMBER(SEARCH("apple",A2)). With the word apple anywhere…
- Isnumber in C++: Standard Function or Platform Extension?No: C++ has no standard function named isnumber. To test whether one character is a decimal digit, use…
- Excel Lookup Function Examples: XLOOKUP, VLOOKUP and MoreExcel lookup functions find a value in one range and return a related value from another. For example,…
- Excel Test If Two Cells Are Equal: Formulas and FixesTo test whether two cells are equal in Excel, enter =A1=B1 in another cell, replacing A1 and B1…
- Lock a Named Range in an Excel Formula?Usually, you do not need to add dollar signs to lock a named range in an Excel formula:…
- Excel Formula for Counting Unique ValuesIn Excel for Microsoft 365, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0) to count distinct nonblank values in A2:A100. It returns 0 if…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.