How to Filter a Column in Excel by Dates or Date Range

Formulas & functions · Updated November 20, 2026

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 a date option under Date Filters or select the dates you want. You can show a particular day, month, year, or date range while leaving the original rows in place. Before filtering, make sure the column contains real Excel dates and that your data has a clear header row.

What You’ll Need

  • An Excel workbook with a column of dates and a header, such as Order Date.
  • A continuous data range with one header row. Blank rows or columns inside the range can make Excel detect only part of the data.
  • For a range filter, the start and end dates you want to include. Check the date format your workbook uses, such as month/day/year or day/month/year.

Step-by-Step

  1. Check the date column. Click a few date cells and look at the formula bar. A real Excel date is stored as a number, even though it is displayed in a date format. Usually, dates align to the right by default, while text aligns to the left, but alignment alone is not a reliable test. If the dates were pasted or imported, confirm that Excel recognizes them as dates before continuing. A filter menu that groups values by year, month, and day is a useful sign that Excel recognizes them.
  2. Make sure the data is organized as one list. Keep one header row at the top and put each record on its own row. Avoid merged cells in the header and blank rows within the records. If your data is in a formal Excel table, click inside it; its header filter buttons may already be on. To create a table, select the data and choose Insert > Table, then confirm that My table has headers is selected.
  3. Turn on filtering if needed. Click a cell inside the data range, then select Data > Filter. Excel adds a drop-down arrow to each header. On Windows, Ctrl+Shift+L toggles filters for the selected range; if the shortcut is inconvenient or behaves differently with your keyboard layout, use the ribbon command. In Excel for Mac, use Data > Filter; the exact shortcut can depend on the keyboard and macOS settings. Excel for the web also has the Filter command on the Data tab.
  4. Open the date column’s filter menu. Click the arrow in the header for the date field, not an arrow in a different column. If the list shows date groups such as years and months, expand the year or month to see more specific dates. The checkboxes let you include or exclude individual periods. If the menu instead shows text values that look like dates, Excel may have stored some or all of them as text; see Troubleshooting.
  5. Choose the kind of date filter. For built-in choices, point to or select Date Filters. Depending on your data and Excel version, options can include Equals, Before, After, Between, and preset periods such as this month or last year. Choose a preset when it matches your task, or choose Between to enter a beginning and ending date. If your menu shows grouped date checkboxes, you can also select only the year, month, or day values you need and clear Select All first.
  6. Enter the range or condition. In the filter dialog, enter dates in a format Excel recognizes in your workbook. For example, to show records from April 1 through April 30, enter those dates as the lower and upper limits. If the dialog offers comparison choices, use is after or equal to for the start and is before or equal to for the end when you want both boundary dates included. For a single date, use Equals; for dates earlier or later than a cutoff, choose Before or After. Select OK to apply the filter.
  7. Check the visible results. Excel hides rows that do not meet the condition; it does not delete them. Look at the row numbers and the filter icon in the header to confirm that a filter is active. Check a few visible records against your intended start and end dates. If a total or summary is meant to reflect only the visible records, confirm that its formula is designed to respond to filtered rows; ordinary totals may still include hidden records.
  8. Change or clear the filter when finished. Open the same date-column arrow to choose a different condition. To show every date again, choose Clear Filter From followed by the column name, or use Data > Clear to clear filters across the range. The filter buttons can remain on after clearing, ready for the next search. To remove the buttons entirely, choose Data > Filter again.

Common Mistakes

Filtering text that only looks like dates: A value such as 04/05/2026 can be interpreted differently depending on regional settings, or it may be plain text. Excel cannot reliably apply calendar-based date filters to text values. Check whether the filter menu groups dates into calendar periods; if it does not, fix the underlying values first rather than choosing a text filter that happens to match their appearance.

Using the wrong date order: In some regional settings, 03/04/2026 means March 4; in others, it means April 3. Confirm how Excel interprets the date before applying a range. If there is any ambiguity, enter dates using a clear format accepted by your locale, or choose dates from the date picker when one is available.

Filtering the wrong range: If the date column is separated from the rest of the records by a blank column or row, Excel might treat it as a separate list. Filtering that list can hide dates without hiding the matching record details. Keep the dataset contiguous, then click inside it before turning on Filter.

Forgetting that filters hide rows: A filtered-out record is still in the workbook. This is useful for temporary views, but it can cause confusion when copying, totaling, or printing. Check the active filter icon and clear filters before assuming rows are missing.

Overlooking times stored with dates: A cell can contain both a date and a time even when its display shows only the date. A value on the last day of a range may be later than midnight, which can matter for exact comparison criteria. If the column contains timestamps and the endpoint behaves unexpectedly, use a date-only helper column or set the upper condition to before the day after your intended end date.

Tips

  • Convert frequently filtered data to an Excel table with Insert > Table. Tables keep filter buttons attached as you add rows and make it easier to work with the full dataset.
  • Use a preset such as This Month when you want a period relative to today. Use an explicit start and end date when the same fixed period should be repeatable later.
  • To include the entire end date in a timestamp range, consider filtering from the start date up to, but not including, the next day. Another option is a helper column that removes the time portion. With timestamps in A2 downward, enter =INT(A2) in a helper cell on the same row, fill it down, format the helper column as a date, and filter that column. For example, a timestamp of April 30 at 3:00 PM becomes the date-only value April 30.
  • Give the date field a specific header, such as Invoice Date or Ship Date, especially when the sheet has several date columns. This reduces the chance of filtering the wrong field.
  • Before sharing or printing a filtered view, check whether you want only the visible rows or the entire list. Clear filters when the recipient should see all records.

Troubleshooting

The menu has no Date Filters options: Excel may be treating the entries as text, or the column may contain a mixture of text and dates. Select a few cells and check the formula bar and number format. If an imported column is consistently recognized as text, select it and use Data > Text to Columns, choose the appropriate date order in the conversion options, and finish the wizard. Make a copy first if the column contains mixed formats, since a conversion can change values. You can also re-enter a small sample of dates to check whether the locale is causing the problem.

Some records disappear even though they seem to be in range: Check the year and the date order in the filter dialog. Also check for times attached to dates, hidden spaces or text values, and dates that were interpreted in a different locale. Clear the filter, inspect the missing records, and verify their actual cell values rather than relying only on how they are displayed.

The filter arrow is missing: Click inside the data and choose Data > Filter. If the arrow appears only on part of the list, clear any blank rows or columns splitting the data, select the intended range, and apply the filter again. In a protected worksheet, filtering may be unavailable unless the sheet protection settings allow it.

The filter shows no matching rows: Recheck the date limits and ensure the start is not later than the end. Clear other column filters temporarily; a second active filter may be excluding otherwise valid rows. If the data includes times, try a date-only helper column as described above.

The results change after new rows are added: If you used a normal range, the new rows may sit outside the filtered area. Convert the data to a table or update the range before filtering again. Also check that new dates follow the same data type and format as the existing entries.

Frequently Asked Questions

Can I filter a date column to show one month?
Yes. Open the date column menu and choose Date Filters and a month-based preset if it fits, or use the grouped year and month checkboxes. If you need a particular month in a past year, select that year and month or enter the month’s first and last dates with Between.

Can I filter dates between two dates, including both endpoints?
Yes. Choose Date Filters > Between and set the lower limit to the start date and upper limit to the end date. If the dialog provides comparison operators, choose after-or-equal for the start and before-or-equal for the end. For timestamps, consider filtering a date-only helper column so times do not affect the boundary.

Does filtering delete the other rows?
No. Excel hides rows that do not meet the filter. Clear the filter to display them again. Avoid deleting visible rows unless you intend to remove data from the workbook.

Can I filter by dates and another column at the same time?
Yes. Apply a filter to the date column and then filter another column, such as Region or Status. Excel displays rows that meet both active filters. Clear either column’s filter separately if you want to broaden the results.

Why does Excel show dates as individual text entries instead of a calendar hierarchy?
The values may be stored as text, the column may mix text with real dates, or Excel may not have detected a consistent date field. Convert the entries to genuine dates, check that they use a consistent interpretation, and reopen the filter menu.

Do the steps differ in Excel for Mac or Excel for the web?
The basic method is similar: use Data > Filter, open the date-column menu, and choose a date condition. Menu layout and available shortcuts can vary by platform and update. On Mac or the web, use the ribbon command if a Windows keyboard shortcut is unavailable.

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.