Excel Pivot Table Filter After a Date: Steps and Fixes

Charts & pivot tables · Updated November 19, 2026

To show PivotTable records later than a chosen date, open the date field’s dropdown, choose Date Filters > After, enter the cutoff date, and select OK. If Date Filters is missing, the source dates may be stored as text, or the field may be grouped into months or years rather than showing individual dates.

Apply an After date filter

These steps are for Excel for Microsoft 365 on Windows. Put the date field in the PivotTable’s Rows or Columns area first; those fields expose the date-condition menu. Then apply the filter:

  1. Select a cell in the PivotTable and locate the dropdown beside the date field name. In Compact Form, the button may say Row Labels; open it and choose the date field if Excel asks which field to filter.
  2. Point to Date Filters, then select After. Depending on the menu and field, Excel may show an ellipsis, such as After…, before opening the condition dialog.
  3. Enter the cutoff date in the dialog and select OK. Enter a date Excel recognizes, such as 1/15/2025, rather than a text label such as mid-January.
  4. Check the results and the filter indicator on the field. The PivotTable now displays matching date items and recalculates its summaries from the visible records.

For example, if the date field contains daily sales and you filter after January 15, 2025, the PivotTable excludes earlier dates and keeps dates later than the cutoff. The menu’s After condition is a comparison, not a command to show a fixed number of days. If you need a rolling period such as the last 30 days, use a date range or a helper field rather than assuming After updates itself to mean the last month.

What the filter changes

A PivotTable date filter limits the date items included in that PivotTable; it does not delete or alter rows in the source data. Other fields, such as product or region, can still have their own filters. The values in the PivotTable are then summarized using the records that remain after the filters are applied.

After is generally a strict comparison: a date equal to the cutoff is not later than it. If the cutoff day should be included, inspect the comparison choices available in the date-filter dialog. Where Excel offers an inclusive choice, use it. Otherwise, use a date-range approach that includes the boundary or adjust the cutoff carefully. This distinction matters for reports where a start date is meant to include every transaction on that day.

The filter applies to the field you selected, not automatically to every date field in the source. If a table has Order Date and Ship Date, filtering Order Date does not also filter Ship Date. A PivotTable can also have more than one date field, so confirm the field name shown in the dropdown before applying a condition.

Choose between After, Between, and a timeline

Excel’s date-filter options are useful for different reporting questions. Choose the one that matches the rule you want, rather than manually hiding individual date items:

  • After: keep dates later than one cutoff. Use it for questions such as which orders came in after a launch date.
  • Before: keep dates earlier than a cutoff, for example transactions before a policy change.
  • Between: set a lower and upper date for a reporting period. This is usually clearer for a month, quarter, or custom interval.
  • Timeline: select a range visually and switch its scale between days, months, quarters, and years. It is convenient for interactive reports, but it is not a replacement for a precisely stated comparison rule.

If you need the filter to move with the current date, a fixed After date will not automatically become a rolling window. You can update the cutoff when preparing each report, use a timeline, or add a calculated helper column to the source that labels rows according to your reporting rule. Choose a method that makes the rule visible to whoever will maintain the workbook.

Check whether Excel recognizes the source dates

A date can look correct on the worksheet but still be text. Excel stores genuine dates as numeric serial values and applies a date display format; text dates do not behave like date values in a PivotTable. A common cause is importing data where dates use a different regional order, such as day/month/year in a file opened on a month/day/year system.

To check a source value, select its cell and inspect the formula bar and number format. Changing the display format alone does not convert text into a date. If the values came from a text file, use Data > Text to Columns and choose the correct date order in the conversion steps, or convert them using a reliable import process. Check a sample of converted values before refreshing the PivotTable, especially where day and month numbers could be confused.

Blank cells and mixed data types can also make a date field behave unexpectedly. Clean the source column so it contains valid dates consistently, and decide how blank or invalid rows should be treated. Then refresh the PivotTable. If the field still has no Date Filters menu, remove it from the PivotTable and add it again after correcting the source.

Understand grouped dates and date hierarchies

Excel may automatically group dates in a PivotTable into Years, Quarters, and Months. In that case, the visible field may represent a group rather than each original date. A filter on Months can select month names, but it may not express the exact cutoff you intended; for instance, selecting March can include March from multiple years.

For an exact date condition, use the original date field rather than a month or year group. If necessary, right-click a grouped date item and choose Ungroup, then open the dropdown on the ungrouped date field and apply Date Filters > After. If the workbook uses a date hierarchy, expand it or add the underlying date field from the PivotTable Fields pane. Field names and hierarchy layout can vary with the data source, but the goal is to filter the field containing the actual dates.

Grouping is still valuable when the report is meant to compare months, quarters, or years. Keep the grouped fields for the summary and use the actual date field to set the precise boundary. That separates the reporting display from the filtering rule.

Account for timestamps and cutoff-day records

Some source columns contain date and time values, even when cells are formatted to display only a date. Excel stores a time as a fractional part of a day. For example, a transaction at 3 p.m. on the cutoff date is later than midnight at the start of that date, so a comparison to a date-only cutoff can include it even when you meant to exclude the entire cutoff day.

Decide whether your rule concerns exact moments or calendar days. If you want every record after a particular timestamp, use a cutoff that includes the intended time. If you want whole calendar days, make the rule explicit: for records after January 15, for example, the desired first calendar day may be January 16. A date-only helper column in the source can make day-level reporting easier when the original field contains times. Check that the helper is a real date value, include it in the PivotTable source, and refresh.

This is also why a PivotTable may show a date that appears to equal the cutoff. The displayed format can hide the time portion. Temporarily display the source values with a time format to see whether records on that day have different times.

Refresh the PivotTable and keep its source current

Changing the source data does not always update a PivotTable immediately. After correcting or adding records, right-click inside the PivotTable and choose Refresh, or use PivotTable Analyze > Refresh. If you added rows beyond the original source range, confirm that they are included in the PivotTable’s data source; a refresh cannot include rows outside that range automatically.

For recurring lists, formatting the source as an Excel table helps the source range expand when rows are added. After adding rows, refresh the PivotTable so its cache includes them. A fixed After condition remains a fixed cutoff; it does not mean after the latest date in the refreshed data. Also check whether new dates are visible after refreshing, since an existing filter can continue to hide items that do not meet its condition.

Fix common date-filter problems

If the expected menu or results are missing, work through these checks before rebuilding the PivotTable:

  • Date Filters is unavailable: confirm that the field contains real dates and is in Rows or Columns, not only the Filters area. Look for a grouped field or hierarchy and try the underlying date field.
  • Excel rejects the cutoff: enter a valid date in the workbook’s regional format, or use the date picker if the dialog provides one. Avoid typing a month name or an ambiguous date string.
  • Some dates are absent: inspect source blanks, text dates, hidden filters on other fields, and whether the source range includes all rows. Refresh after fixing the source.
  • The cutoff day appears unexpectedly: check for hidden times in the source and confirm whether the boundary should be inclusive or exclusive.
  • Months from different years seem combined: filter the full date or include the year field; a month label alone does not identify a unique calendar month.

With an external data source or a Data Model, available filtering options can differ from those in a basic range-based PivotTable. If the ordinary Date Filters submenu is absent even though the field contains dates, check how the PivotTable was created and whether its source field is exposed as a date. A calendar table or source-side date column may be needed for more advanced models.

Use a timeline for interactive date ranges

A timeline is a visual control for filtering PivotTable dates. Select the PivotTable, choose PivotTable Analyze > Insert Timeline, select the date field, and confirm. Use the timeline’s scale selector to show days, months, quarters, or years, then drag or click to select the range. This makes it easy for report readers to adjust a period without opening a filter dialog.

Timelines are particularly useful on dashboards and can control multiple PivotTables when those PivotTables share a compatible data source. Use the timeline’s Report Connections option to choose connected PivotTables. If the control is unavailable, verify that a date field is in the source and that the PivotTable supports timelines. For a one-time exact cutoff, the field’s After filter is usually more direct; for exploration, the timeline is often easier to understand.

Frequently Asked Questions

Can I filter a PivotTable to dates after today?
Yes. Apply Date Filters > After and enter today’s date as the cutoff. That cutoff is fixed when entered; it does not automatically roll forward each day unless you update it or use another dynamic reporting method.

Why does my PivotTable show Date Filters only sometimes?
The menu depends on Excel recognizing the field as dates and on the field being available at the relevant level. Text dates, grouped fields, and some external or Data Model sources can change which commands appear.

Does After include the date I enter?
After normally means later than the entered value, not equal to it. Check the dialog for an inclusive comparison if you need to include the cutoff date, and take hidden times into account.

Can I filter a PivotTable between two dates?
Yes. Open the date field dropdown, choose Date Filters > Between, and enter the start and end values. Confirm that the selected field is the full date field, not only a month or year group.

Will new source rows appear after I apply the filter?
Only if the rows are within the PivotTable’s source range and you refresh the PivotTable. The After condition remains in place, so new rows appear only when their dates satisfy that condition.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.