To filter 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 and a condition such as Between. Filtering hides rows that do not meet the condition; it does not delete them. Before you start, make sure the dates are in one column with a clear header and are stored as real Excel dates, not text.
What You’ll Need
- An Excel workbook containing a list of records, such as orders, appointments, or tasks.
- A column with one date per record, plus a header such as Order Date. Avoid blank rows or merged cells inside the data range.
- Excel for Microsoft 365 on Windows. The main steps are similar in Excel for Mac and Excel for the web, though the ribbon layout may differ slightly.
Step-by-Step
- Check the layout of your data. Put each record on its own row, with column names in the first row of the range. Keep the date column consistent: a row should contain one date value, rather than a mixture of dates, notes, and multiple dates. For example, if column C is named Order Date, each order should have its date in that column. Make a copy of the workbook first if the data is important or you plan to reorganize it.
- Confirm that Excel recognizes the values as dates. Select a few cells in the date column and look at the Number Format box on the Home tab. A date format such as Short Date is a useful sign, although the box alone does not prove every value is a true date. A practical check is to select a cell and temporarily choose Home > Number Format > General. A real date usually changes to a number, because Excel stores dates as serial values. Undo the format change or set the column back to a date format afterward. If the entries stay as text, fix those values before filtering.
- Select a cell inside the data range. Click any populated cell in the list, not just the date column. Excel normally detects the surrounding block of data. Check that there are no completely blank rows or columns splitting the list; a break can cause Excel to apply the filter to only part of your records.
- Turn on the filter arrows. On the ribbon, choose Data > Filter. Drop-down arrows should appear beside the column headers. If they do not, verify that you selected a cell in the data and try the command again. You can also format a well-structured range as a table with Home > Format as Table; tables include filter arrows in their headers.
- Open the date-column menu. Click the arrow beside the date header, such as Order Date. If Excel recognizes the column as dates, the menu will include Date Filters. If you see only text-oriented choices, such as Text Filters, or the dates are mixed into a flat checklist, Excel may be treating at least some entries as text. Use the troubleshooting guidance below before relying on the results.
- Choose the date condition that fits your question. For a range, point to Date Filters and select Between. Enter the beginning and ending dates in the dialog, then confirm. For example, to show records from April 1 through April 30, enter those two dates as the limits. Excel includes matching dates on the boundaries. The two boxes allow you to set both limits; make sure the dialog uses And when you want dates that satisfy both limits. For a single cutoff, choose Before or After. For one exact date, choose Equals.
- Use a built-in period when that is quicker. In the date menu, Date Filters offers useful relative options such as Today, Yesterday, This Week, Last Month, and Year to Date. The available choices can depend on the selection and Excel version. Choose All Dates in the Period to select a calendar month, quarter, or other listed period. A period filter can be more convenient than typing two boundaries, especially for a whole month. Check the visible results to make sure the chosen period matches the dates you intended.
- Review the filtered list. Rows that do not match are hidden, and the filter arrow typically shows a filter indicator. Read a few visible dates and check the first and last records. If you filter more than one column, Excel combines the conditions: a row must satisfy the active filters to remain visible. To see all records again, open the date-column menu and choose Clear Filter From the date column, or use Data > Clear to clear filters across the range.
In Excel for Mac, use the Data tab and choose Filter to show the arrows; then open the date header menu and select the date condition. Excel for the web has a similar Data > Filter workflow, though some menu labels or dialog layouts can vary. If your data is in a table, its header arrows provide the same date-filter options.
Common Mistakes
- Assuming a date-looking entry is a date value. Text such as 04/05/2026 can look like a date while remaining text, or it can be interpreted differently under another regional date convention. Filtering may then omit it or sort it in an unexpected order.
- Choosing a date range with the wrong boundaries. For a full month, enter the first and last calendar dates, rather than stopping at the day before the month ends. When the entries include times as well as dates, a last-day boundary at midnight can exclude later times on that day. For a simple date-only list, use the last date of the period and check the results; for date-and-time records, use a range that safely covers the intended final day.
- Filtering only part of the list. Blank rows, blank columns, or a selected cell outside the data can make Excel detect the wrong range. Some records may appear unaffected because they are outside the filtered block.
- Thinking hidden rows have been removed. A filter only hides rows from view. Clearing it restores them. Do not copy or delete visible rows unless you have checked which records are selected and what you intend to change.
- Mixing dates and other content in one column. A header is fine, but labels, notes, and date values together can stop Excel from offering date-specific filters or make the results unreliable.
Tips
- Use a consistent date format, such as 2026-04-15 or a familiar regional format, and keep the date column separate from time, status, and comments. The display format can be changed through Home > Number Format without changing the underlying date value.
- For recurring work, convert the range to a table using Home > Format as Table. When you add records directly below a table, it can expand to include them, and the header filters remain available. Check that newly added records are part of the table before filtering.
- Use a filter for temporary viewing, not as a substitute for sorting or permanently removing records. If you need to arrange the visible records chronologically, use the date menu’s Sort Oldest to Newest or Sort Newest to Oldest option.
- When selecting a month, consider whether you mean a calendar month or the last 30 days. All Dates in the Period selects a calendar period; a relative choice such as Last Month is not the same as a rolling 30-day window.
- Keep a note of the selected criteria if you share a filtered workbook. Other people may open it and see only the visible subset, even though the remaining rows are still present.
Troubleshooting
Date Filters is missing. First inspect the column for text values, blank cells containing spaces, and entries with a different date pattern. A useful repair method is to select just the affected cells, choose Data > Text to Columns, select Delimited and move through the wizard without choosing a delimiter, then set the column data format to Date and select the correct order, such as MDY or DMY. Finish the wizard and check several converted values. This method can change how ambiguous dates are interpreted, so use the order that matches the original data and your region. If conversion is unsuitable, correct the source values or import them again with the right date settings.
Some records disappear unexpectedly. Clear the filter and inspect the entire date column, including the records near the start and end of the period. Check whether dates include times, whether a date was entered with a different year or regional order, and whether another column also has an active filter. Clear the other filters temporarily to isolate the cause. For date-and-time data, a cell displayed as a date may still contain a time that is not visible in the current number format.
The filter arrow does not appear on every header. Confirm that the list has one header row and no merged header cells. Click inside the intended range and choose Data > Filter again. If Excel has detected only a portion of the list, remove blank separator rows or turn the whole block into a table with Home > Format as Table, checking the range shown in the dialog.
New rows are not included. If the list is a normal range, clear the filter, select the full expanded range, and reapply Data > Filter. A table usually expands as records are added directly below it, but a blank row between the table and new entries can prevent that. Add the records directly below the last table row or resize the table so it includes them.
Frequently Asked Questions
Can I filter for dates between two dates?
Yes. Open the arrow in the date header, choose Date Filters > Between, enter the start and end dates, and confirm. Check both limits and the visible results, particularly if your values include times.
Can I show only one month?
Yes. Choose Date Filters > All Dates in the Period and select the month, if it appears in the menu. Alternatively, use Between and enter the first and last date of the month.
Does filtering delete rows?
No. It hides rows that do not match. Choose Clear Filter From the date column, or use Data > Clear, to show the hidden records again.
Why does Excel show Text Filters instead of Date Filters?
Excel may be reading the entries as text, or the column may contain a mixture of text and dates. Convert the values to real dates consistently, then reopen the filter menu.
Can I filter by date and another field at the same time?
Yes. Apply a date condition, then open another column’s filter menu and set its condition. Excel shows rows that meet all active column filters.
Can I filter dates in Excel for the web or Mac?
Yes. Both provide filters on column headers and date conditions. The ribbon or dialog can look different from Excel for Windows, but the basic process is to turn on Filter, open the date header menu, and choose a date rule.
Related
- How to Duplicate an Excel File Shortcut on Windows
- How to Duplicate a Page in Excel and Keep Its Layout
- Duplicate a Sheet in Excel: Keyboard Shortcut and Steps
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Filter Duplicates: Keep the First RecordTo keep the first occurrence of each value in Excel, select the full data range and choose Data…
- Excel SUMIF Between Two Dates: The Right FormulaTo sum values for dates within an inclusive start-to-end range in Excel, use SUMIFS, which supports more than…
- How to Drag a Number Sequence in Excel Without GapsTo drag a number sequence in Excel, enter the first two numbers in adjacent cells, select both cells,…
- PMT Function Negative in Excel? The Sign Rule ExplainedYour PMT function is usually negative because Excel treats the loan amount and its repayments as cash flows…
- How to Filter Rows by Color in Excel: A Practical GuideTo filter rows by color in Excel for Microsoft 365 on Windows, select a cell in your data,…
- Excel List Unique Entries with Formulas and Built-In ToolsTo list unique entries in Microsoft Excel for Microsoft 365, enter =UNIQUE(A2:A100) in an empty cell, replacing the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.