How to Filter Dates in Excel by Day, Month, or Range

Formulas & functions · Updated November 20, 2026

To filter dates in Excel, select a cell in your data, choose Data > Filter, open the arrow in the date column, and choose Date Filters. Select a preset such as This Month or Between, or check the particular dates you want to display. Filtering hides rows that do not match; it does not delete or rearrange the underlying records permanently.

How Excel date filters work

An Excel filter compares the values in a column with the conditions you choose, then temporarily hides rows that do not match. A date filter is available when Excel recognizes the column values as dates. The visible arrow beside the column heading opens a menu with a search box, date checkboxes, and, where applicable, a Date Filters submenu.

Excel stores genuine dates as serial numbers, with the displayed format controlling how they look. For example, two cells may show 3/8/2026 and March 8, 2026 but represent the same date value. A filter can therefore work across different display formats as long as the entries are real dates. Text that merely looks like a date may not be treated the same way.

Filtering is not sorting. Sorting changes the order of the visible records, while filtering limits which records are shown. You can apply both, and you can remove a filter to show the rows again.

Filter dates with the column dropdown

For a straightforward filter in Excel for Microsoft 365 on Windows, use this sequence:

  1. Arrange the data in columns with one clear header row, such as Date, Customer, and Amount. Avoid blank header cells and blank rows inside the data.
  2. Click a cell within the data range. If it is not already an Excel table, choose Data > Filter. Excel adds dropdown arrows to the header row.
  3. Open the arrow on the date column. Choose Date Filters, then select a condition such as Before, After, Equals, or Between. The precise choices shown can depend on the date data and Excel version.
  4. Enter the date or date limits in the dialog and confirm. Excel displays the rows that satisfy the condition.

For example, to see records from March 1 through March 31, 2026, choose Between and enter those two boundary dates. Check the resulting list against the date column and any other conditions: date filters narrow rows, so a correct-looking total can still be incomplete if another column is filtered too.

You can also open the date dropdown and select or clear individual dates in its checklist. This is handy for a few specific days, but a condition such as Between is usually easier to maintain for a large or changing date range.

Filter by day, month, quarter, or year

The Date Filters submenu is useful when you want a period relative to the current date or a calendar period rather than manually selecting every date. Depending on the data and interface, options can include Today, Yesterday, Tomorrow, This Week, Last Month, This Quarter, This Year, and Year to Date. These relative options are useful for recurring workbooks: a This Month filter can show the current month when reopened later, rather than staying fixed to a month selected once.

Excel may also display dates in a hierarchy in the dropdown checklist, with expandable years, months, and individual days. If it does, selecting a month or year can include all dates within that period. Some versions or datasets instead show individual date values or a Date Filters menu. If a month-level choice is not offered, use Date Filters > Between and enter the first and last day of the period.

Be precise about what a period means. This Year generally refers to the calendar year, while a fiscal year may begin in a different month. For fiscal reporting, filter a specific start and end date with Between, or add a fiscal-year field to the data. Similarly, a preset for This Week may follow Excel’s regional or system conventions; for a report with a defined week start, use explicit date boundaries.

Prepare the data for reliable filtering

Filters work best when each row is one record and each column contains one kind of information. Use a single header row, keep dates in a dedicated column, and do not place explanatory titles or subtotals inside the data block. If the range has no blank rows or columns splitting it, clicking inside it and choosing Data > Filter normally lets Excel identify the region.

For an expanding list, convert the range to a table with Insert > Table and confirm that the table has headers. Tables add filter arrows automatically and generally extend to include new rows typed or pasted directly beneath them. They also make it easier to keep a consistent header row as records are added. Check that a newly added record is actually part of the table before assuming it will appear in a filtered view.

Use a consistent date format for readability, but remember that formatting alone does not convert text into a real date. If some values are left-aligned, refuse to group with the other dates, or appear as separate unexpected entries in the filter list, inspect their underlying values. Imported CSV files are a common source of text dates, especially when the file’s day-month order differs from the computer’s regional settings.

Fix dates that will not filter correctly

When a date filter is missing or produces surprising results, first check whether the entries are genuine Excel dates. Select a problem cell and look at the formula bar and number format; changing the display format may reveal a serial number for a real date, but formatting text as Date does not necessarily convert it. For imported data, use Data > Text to Columns and review the date format settings, or convert the values using an appropriate method for the source’s day-month order. Make a copy before changing a large imported column.

Other common causes include:

  • Mixed text and dates: A column can contain real dates alongside text entries such as Not available. Clean or convert the inconsistent values before relying on period filters.
  • Hidden times: A cell can contain both a date and a time while displaying only the date. A filter for a single date may include all times on that date, but a boundary entered as midnight can exclude later times if the condition is set as an exact timestamp. For a full-day range in timestamp data, set the upper boundary thoughtfully or use a date-only helper field.
  • Regional date ambiguity: An entry such as 04/05/2026 can mean April 5 or May 4. Confirm the intended order before converting or filtering; the display alone may not settle the question.
  • Incomplete selected range: If Excel did not include every row when Filter was applied, records outside that range will not be filtered with the rest. Remove the filter, select the full data range, and apply it again, or make the records an Excel table.

Also check whether a different column is already filtered. Multiple active filters combine: a row must satisfy the active conditions to remain visible. That can make a date filter seem to have removed records that actually fail a category, location, or status filter.

Combine filters and clear them safely

You can filter a date column and another column at the same time. For example, show orders between two dates and then choose one region in the Region dropdown. Excel displays rows meeting both conditions. Within a date column, use a date condition or select the dates needed; avoid assuming that separate filter actions are independent lists that will add results together.

To clear a filter from one column, open that column’s dropdown and choose Clear Filter From [column name], when that command is available. To remove all active filters but retain the dropdown arrows, use Data > Clear. To turn off the arrows entirely, choose Data > Filter. Clearing or turning off a filter reveals hidden rows; it does not restore a previous sort order or undo edits made to cells.

If the worksheet appears to have lost records, check the row numbers for gaps and inspect the filter icons in the headers. A funnel icon indicates that a column is filtered. Save or make a copy before substantial cleanup, but ordinary filtering itself is a view operation, not deletion.

Alternatives for recurring date reports

For occasional exploration, the dropdown filter is usually quickest. For a report that needs to be refreshed regularly, a table with a saved filter can make the source data easier to manage. If readers need to switch dates interactively, a PivotTable can summarize dates and group them by months, quarters, or years when the source dates are valid. Grouping is most useful for summaries; it is different from filtering the original rows directly.

A helper column can make a business rule explicit, such as labeling each record with a fiscal year or a reporting week. This is preferable when a standard calendar preset does not match the organization’s definition. Dynamic-array formulas can also return matching rows in Microsoft 365, but they create a separate result area and require care if the source data changes; they do not replace the built-in filter on the source range. For most users who simply want to view a period, the date dropdown remains the least complicated option.

Excel for the web also supports column dropdown filters, including date filtering, though the layout and available controls can differ slightly from desktop Excel. On Mac, start from the Data tab and use Filter; menu layout and keyboard shortcuts can vary by Excel release and keyboard settings.

Frequently Asked Questions

How do I filter Excel dates by month?
Open the date-column dropdown and look for a grouped year-and-month checklist. If Excel does not show months, choose Date Filters > Between and enter the month’s first and last dates. For example, use March 1 and March 31 to include the full month of March in a non-time-stamped date column.

Why does Excel show dates as numbers or not recognize them?
Real Excel dates are stored as serial values, so a number format can make them display as dates. If formatting does not help, the entries may be text imported from another system. Check the source’s date order and convert the text values to actual dates before filtering.

Can I filter a date range without hiding the original data?
Yes. The ordinary AutoFilter hides rows that do not meet the condition; it does not delete them. Clear the filter from the date dropdown, or use Data > Clear to clear active filters and show the rows again.

Can I filter dates and categories at the same time?
Yes. Apply the date condition, then choose a category in its own column’s dropdown. Excel keeps rows that meet both filters, so clear any unrelated active filters if the result is smaller than expected.

How do I filter dates that include times?
Excel can store a time as part of a date value even if the cell displays only the date. For a whole day, ensure the filter boundaries include all times on that date; a date-only helper column can simplify repeated reports when the source contains timestamps.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.