Excel Filter Dates Before Today: Steps That Work

Formulas & functions · Updated November 19, 2026

To filter Excel dates before today, open the date column’s filter menu and choose Date Filters > Before, then enter today’s date. For a filter that updates against the current date, add a helper column with =AND(ISNUMBER(A2),A2<TODAY()), fill it down, and filter that column to TRUE.

Use Excel’s built-in date filter

The built-in filter is the quickest choice when you need a one-time view of records earlier than a particular date. It does not require a formula or a change to your source data.

  1. Click a cell in your data range. If the data is not already filtered, select the header row and choose Data > Filter.
  2. Open the drop-down arrow in the column containing the dates.
  3. Choose Date Filters > Before.
  4. Enter today’s date in the filter dialog and confirm. Excel keeps dates strictly earlier than the date you entered.

For example, if today is November 3, 2026, entering November 3 shows November 2 and earlier. November 3 itself is excluded. The filter changes which rows are displayed; it does not delete or alter the hidden records. To show everything again, open the column filter and choose Clear Filter From that column, or use the clear-filter command on the Data tab.

Excel for Microsoft 365 on Windows is the reference here. The Mac and web versions also provide column filter menus and date-filter choices, although the menu layout can differ slightly. If you do not see date-filter options, check that the column contains real Excel dates rather than text.

Make the cutoff update automatically with TODAY

The built-in Before filter uses a date you enter; it is not the best option for a workbook that should always mean “earlier than the current day.” A helper column can calculate that test for every row, using the computer’s current date.

Assume the dates are in A2:A100 and row 1 contains headers. Put a header such as Before today? in B1. In B2, enter this formula, then fill it down through the rows of data:

=AND(ISNUMBER(A2),A2<TODAY())

For the example, if the system date is November 3, 2026, an actual date of November 2 in A2 returns TRUE; November 3 and November 4 return FALSE. A blank or text value also returns FALSE because ISNUMBER checks that A2 is a numeric Excel date value. Filter column B to TRUE to show only qualifying rows. This formula is useful because it avoids treating a blank cell as an old date.

TODAY returns the current date without a time. Excel stores dates as serial numbers, so the less-than comparison works chronologically. With date-and-time entries, every time on the current date is greater than or equal to midnight at the start of today and is therefore excluded. That matches the usual meaning of “before today.”

Understand what Excel means by a date

Excel generally stores dates as numbers, with the displayed date format controlling how those numbers look. A cell that displays 11/02/2026 may be a genuine date, while another cell displaying the same characters may contain text. The two can look identical but behave differently in comparisons and date filters.

To check a suspect value, select the cell and look at the formula bar and number format. You can also temporarily change the number format to General: a real date normally appears as a serial number. Do not rely on appearance alone, especially for files imported from a website, CSV, or another system.

Regional settings can also affect interpretation. A string such as 03/04/2026 can mean March 4 or April 3 depending on the date convention used when it was entered or imported. If Excel has interpreted the source incorrectly, filtering cannot repair the underlying meaning. Convert or re-import the values with the correct date order before relying on the results.

Dates with times, blanks, and unusual values

A timestamp combines a date and a fraction representing the time. For instance, records from today at 9:00 a.m. and 5:00 p.m. both fail the test of being less than TODAY(), because TODAY() represents midnight at the beginning of today. This is often exactly what a report needs when it should include only completed days.

Decide what blanks and invalid entries should mean before filtering. The helper formula above deliberately returns FALSE for blanks and text. If you instead want to review those rows, use a separate filter on the original date column or add a distinct data-quality check. Mixing missing values into the “before today” group can make an overdue list misleading.

Also watch for date values outside the expected range. A mistyped year such as 1926 instead of 2026 is still a valid date and will pass the test. A formula can compare values, but it cannot determine whether a date is factually correct; validation rules and source checks are useful for that.

Keep a dynamic filter current

TODAY() is a volatile function: Excel recalculates it when the workbook recalculates. With calculation set to Automatic, opening the workbook or making a relevant edit will normally update the helper results. If calculation is set to Manual, the values may remain stale until you recalculate; press F9 on Windows, or use Formulas > Calculate Now.

There is an important distinction between recalculating a helper formula and refreshing the filter view. The TRUE/FALSE values can change as the date changes, but an existing filter may not immediately show the newly qualifying rows. After recalculation, clear and reapply the TRUE filter if the visible records do not match the updated helper results. This matters for workbooks left open across midnight or used in a manual-calculation environment.

TODAY() follows the date used by the device or environment running Excel. It does not know the time zone or business-day cutoff intended by your organization. If a report must use a specific time zone or a defined operational date, use a clearly maintained cutoff date in a cell rather than assuming the local system date represents that policy.

Choose between a one-time filter and a helper column

Use the built-in date filter when you need a quick, temporary answer and are comfortable entering the cutoff date again later. Use a helper column when the test should stay visible, be easy to audit, or update based on TODAY(). A helper column also makes it clear to coworkers why a particular record is included.

  • One-time review: Date Filters > Before is fast and leaves the data structure unchanged.
  • Recurring report: A helper formula provides a repeatable TRUE/FALSE test, but the filter may need to be reapplied after recalculation.
  • Shared workbook: A named or documented cutoff date can be clearer than relying on each user’s device date.
  • Need to keep all rows visible: Sort the date column oldest to newest or use conditional formatting instead of hiding nonmatching rows.

Filtering is a view, not a permanent separation of records. Copying visible rows to another sheet creates a separate extract, but check whether hidden rows are excluded from the copy operation and retain the original data if it is needed for audit or later reporting.

Common reasons the filter gives the wrong result

If expected rows are missing or extra rows appear, check the data and filter setup before changing the comparison.

  • Dates stored as text: Convert the source values to real dates. Text dates may sort alphabetically or fail date comparisons.
  • Filter applied to only part of the list: Select the complete range or convert the range to a table with Insert > Table, making sure the header option is correct.
  • Blank rows split the data: A blank row can cause Excel to treat adjacent blocks as separate ranges. Remove unnecessary blank rows or create a table.
  • Wrong cutoff: “Before today” excludes today. If you mean “today and earlier,” the condition must include equality; do not use a strict before comparison.
  • Stale helper results: Recalculate the workbook and reapply the filter, particularly if calculation is manual or the workbook crossed midnight while open.

Also confirm that the date column is the one actually being filtered. A workbook may contain an order date, due date, and completion date, and “before today” has a different meaning for each. Check the header and a few visible records against the source before acting on a filtered list.

Frequently Asked Questions

How do I filter dates before today in Excel?
Open the date column’s filter arrow, choose Date Filters > Before, and enter today’s date. For a result that recalculates with the current date, use a helper formula such as =AND(ISNUMBER(A2),A2<TODAY()) and filter its results to TRUE.

Does Excel’s Before filter update automatically tomorrow?
No. A date entered in the built-in Before filter is a fixed cutoff. To base the comparison on the current day, use TODAY() in a helper formula, recalculate as needed, and reapply the filter if the displayed rows do not update.

How do I include today as well as earlier dates?
“Before today” excludes today by definition. If the intended range is today and all prior dates, use a less-than-or-equal comparison in the helper test, and decide whether timestamps later today should also count.

Why does my Excel date filter not recognize dates?
The cells may contain text rather than numeric date values, or the imported date order may have been interpreted incorrectly. Convert the data to genuine dates and verify a few values; changing the display format alone does not convert text into dates.

Will filtering before today delete the other rows?
No. Excel’s filter hides rows that do not match; it does not remove them. Clear the filter to display them again. Delete rows only if you deliberately choose a separate deletion operation.

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.