Use AutoFilter to show only rows within a date range

The fastest way to filter by date in Excel is to turn on AutoFilter, which adds dropdown arrows to your column headers. Click the arrow next to your date column, choose "Date Filters", then pick the range you want — last month, last year, between two specific dates, or before/after a single date. Excel then hides every row that doesn't match, so you see only what you're looking for.

This works on any spreadsheet where your dates are in their own column — a list of file backups with backup dates, a record of documents with creation dates, or a log of when you last updated each file. The original data stays unchanged; you're just hiding rows temporarily.

Key Takeaways

  • AutoFilter is the built-in tool for date filtering and lives in the Data menu — select your data first, then click Data > Filter.
  • Once AutoFilter is on, click the dropdown arrow in your date column header and choose "Date Filters" to pick a range like "last month" or "between two dates".
  • Custom filters let you set exact start and end dates when the preset options don't match what you need.
  • Filtering hides rows but doesn't delete them — turn off the filter to see all your data again.

Turn on AutoFilter in three steps

Start by selecting the data you want to filter. Click any cell in your table, then go to the Data menu at the top of the screen and click Filter. Excel adds a dropdown arrow to the header of every column in that table.

If your spreadsheet doesn't have a header row (a row at the very top with column names), Excel will treat the first row of data as the header. Add one before you turn on AutoFilter if you want to avoid confusion. The header row won't be filtered — only the data below it.

Filter to a specific date range using the dropdown menu

Click the dropdown arrow in the column that holds your dates. A menu appears with options like "Equals", "Before", "After", and "Date Filters". Click Date Filters to see preset ranges: Today, Yesterday, Last Week, Last Month, Last Quarter, Last Year, and others.

If none of those match what you need, click Custom Filter at the bottom of that submenu. A dialog box opens where you can set your own start date and end date. Type or paste the dates in the format your spreadsheet uses (usually MM/DD/YYYY in the United States). Click OK, and Excel shows only rows where the date falls within that range.

To filter by a single date instead of a range, use "Equals" from the first dropdown menu, then type the date you want. Excel will show only rows with that exact date.

Remove or change a filter

To see all your data again, go back to the Data menu and click Filter a second time. This turns off AutoFilter entirely and removes all the dropdown arrows. Your data reappears unchanged.

To change just the date filter without turning off AutoFilter completely, click the dropdown arrow in the date column again and choose a different range, or click Clear Filter at the top of the menu. This removes the current date filter but leaves AutoFilter on for other columns.

Use Standard Filter for more complex date searches

If you need to filter by date and another column at the same time — for example, show me all backups from the last month that are also marked as "complete" — use Standard Filter instead. Go to Data > More Filters > Standard Filter. A dialog box opens with rows where you can set multiple conditions at once.

In the first row, choose your date column from the "Field name" dropdown, pick "is between" or another operator from the middle dropdown, then enter your start and end dates. In the second row, choose "AND" from the left dropdown (so both conditions must be true), then set up your second condition — for example, Status equals Complete. Click OK, and Excel shows only rows that match both conditions.

Know what format your dates are in before you filter

Excel treats dates as numbers underneath the surface, which is why filtering works at all. But the way a date appears on screen (01/15/2024 versus January 15, 2024 versus 2024-01-15) depends on how that column is formatted. When you use Custom Filter or Standard Filter, type your dates in the same format you see in the spreadsheet.

If your dates look like "1/15/24" in the cells but you type "01/15/2024" in the filter box, Excel may not recognize them as the same date. Look at a few cells in that column and match the format exactly. If you're not sure, try the preset date ranges first — they work regardless of how the dates are displayed.

Frequently Asked Questions

Can I filter by month and year without specifying a day?

Yes, using Custom Filter. Set your start date to the first day of the month (for example, 01/01/2024) and your end date to the last day of that month (01/31/2024). Excel will show all rows with dates in between, regardless of the day.

What if my date column has blank cells?

Blank cells are treated as a separate category in the filter menu. When you click the dropdown arrow, you'll see a checkbox for "(blanks)" at the bottom of the list. Uncheck it if you want to hide rows with no date, or leave it checked to include them in your filtered results.

Does filtering delete the rows I'm not seeing?

No. Filtering only hides rows temporarily. When you turn off the filter, all your original data comes back exactly as it was. Nothing is deleted or moved.

Can I filter by a date that's calculated from another column?

Yes, as long as the calculated result is actually a date. If you have a column that adds days to another date using a formula, you can filter that column the same way you would filter any other date column.

How do I filter for dates older than a certain date?

Click the dropdown arrow in your date column, choose Date Filters, then click Before. Type the date you want as your cutoff, and Excel shows only rows with dates earlier than that date.