Google Sheets Filter by Date: A Practical Guide

Yes. In Google Sheets, select your data, choose Data > Create a filter, open the filter dropdown on the date column, and use Filter by condition to show dates that meet your criteria. You can filter for a specific date, a date range, or a relative period, and use a filter view when you want to avoid changing what other collaborators see.

What a date filter does

A date filter hides rows that do not match a condition; it does not delete them or change their values. For example, a sales table with an Order Date column can be filtered to show only orders from March. The other rows remain in the sheet and become visible again when you clear the filter or change the condition.

Google Sheets can apply date conditions when it recognizes the cells as dates. A displayed date is not necessarily a true date value: a cell containing date-looking text may appear just like a date but fail to behave like one when filtered or sorted. This distinction is the source of many date-filter problems.

There are two useful ways to narrow a date column:

Filter by condition: Set a rule, such as a date being before, after, or within a chosen period. This is often the most convenient choice for a range or a relative period.
Filter by values: Select or deselect particular entries shown in the filter list. This can be handy for a small set of known dates, but is less convenient when the list is long or dates change frequently.

Both methods affect which rows are displayed, not the underlying records. If the sheet is shared, remember that an ordinary filter can affect the view other collaborators are using; a filter view is generally safer for individual analysis.

Prepare the data before filtering

Put one field name at the top of each column and keep each record on its own row. A simple table might have Date in column A, Customer in B, and Amount in C, with the records beginning on row 2. Avoid blank rows inside the data range, merged cells in the header area, and extra notes directly beside the table. Those can make it harder for Sheets to identify the full range.

Check that the date column contains actual dates. Select a few cells and look at the formula bar: a recognized date is stored as a numeric date value, even though the cell is displayed in a familiar format. You can change how it appears with Format > Number > Date, but changing number formatting alone does not convert text into a date.

If dates were imported from another system, their interpretation can depend on the spreadsheet locale. For example, 04/05/2025 can mean April 5 or May 4 depending on the expected order. Check the document’s locale under File > Settings before converting or interpreting ambiguous entries. Do not assume that changing the display format resolves a day-and-month ambiguity; confirm what the source data means.

Filter for a date or date range

Click a cell in the data table, or select the full range including its header row.
Choose Data > Create a filter. Filter dropdown icons should appear in the header row.
Click the dropdown in the date column.
Choose Filter by condition and select the date condition that fits, such as an exact date, a date before or after a boundary, or a date between boundaries. The available control may prompt you to choose or enter a date.
Set the date or dates and confirm the filter. The sheet will show matching rows; check the date column and a neighboring field to verify that the result makes sense.

For instance, to review invoices for one month, set the condition to include dates from the first day of that month through its last day. A built-in between condition is a straightforward option for a modest range. If your data includes times as well as dates, inspect records on the boundary: a timestamp such as March 31 at 3 p.m. is later than midnight at the start of March 31, and a rule’s treatment of the boundary matters.

For an exact one-day filter, use the exact-date condition if it appears in the condition choices. Alternatively, use Filter by values and select the date entry. If neither approach returns an expected record, first check whether the cell is a real date or text and whether it includes a time component.

Use relative periods such as today or last week

Relative date conditions are useful for ongoing lists because you do not have to enter a new calendar date every time you review the sheet. In the date column’s filter dropdown, open Filter by condition and look for the available relative-date choices. Depending on the condition menu, choices can include periods such as today, yesterday, tomorrow, or a recent period. Choose the wording that matches the question you are trying to answer, then review the displayed rows.

These rules are different from fixed boundaries. A fixed date range continues to refer to the dates you entered; a relative condition is evaluated in relation to the current date when the filter is used. That makes a relative rule useful for a task list or a current-period report, but less appropriate when you need a reproducible snapshot of a past reporting period. For an archived report, use explicit date boundaries and retain the relevant source data.

Time zones can also matter in spreadsheets that contain timestamps or automatically generated dates. A timestamp close to midnight may fall on a different calendar date depending on how it was recorded. If a report is date-sensitive, establish which time zone and date convention the source uses rather than assuming that the displayed day tells the whole story.

Filter using a custom formula

A custom formula can help when the built-in conditions do not express the rule you need, such as selecting all timestamps in a calendar month. In the date column’s filter menu, choose Filter by condition, then Custom formula is. The formula is evaluated for the rows in the filtered range, so its reference must point to the first data row and use the correct date-column letter.

For example, assume dates or timestamps are in A2:A, the header is in A1, and the filter covers a table whose data starts on row 2. To show records in January 2025, use this custom formula:

=AND($A2>=DATE(2025,1,1),$A2<DATE(2025,2,1))

The first condition includes values at or after January 1; the second excludes values at or after February 1. Together, they include all of January, including timestamps later than midnight on January 31, while excluding February. The dollar sign fixes the column reference, and the row number remains relative so the condition can be evaluated for each record. If your date field is in another column, replace A with that column’s letter; if the data starts on a different row, adjust the row number.

Custom formulas require care: a wrong column or starting row can produce an empty or misleading result. Test the rule against a few known records, especially the first and last dates in the range, before using it for a report.

Fix dates that will not filter correctly

If a date condition hides records you expected to see, troubleshoot the values before changing the filter repeatedly. Common causes include text instead of dates, mixed date conventions, timestamps, an incomplete filter range, and an incorrect header or data layout.

Look for text dates. Imported values may contain leading apostrophes, spaces, or a format Sheets did not parse. Re-entering a date in a recognized format or converting the source data may be necessary. Formatting text as Date by itself does not guarantee conversion.
Check the locale and date order. A day/month mismatch can cause a date to be interpreted differently than intended. Confirm the source convention and the spreadsheet locale before converting ambiguous values.
Check for times. A cell may display only a calendar date while storing a time as well. A boundary rule based on midnight may not include every timestamp on that displayed day.
Confirm the filter range. If new records were added outside the range covered by the filter, they may not be included. Remove or adjust the filter and recreate it with the full table range if needed.
Look for blank or inconsistent rows. Repeated header rows, blank lines, and notes mixed into the table can make the data range or filter results confusing.

To inspect an uncertain cell, select it and review the formula bar and number format. You can also test the same condition on a small copy of the data, keeping the original intact. For imported dates, verify a handful of converted results against the original source rather than trusting a conversion solely because the cells now look like dates.

Choose between a standard filter and a filter view

A standard filter is a good choice when you are working alone or when the shared sheet should show one common filtered result. Create it with Data > Create a filter, then set the date condition from the column dropdown. To remove the filter controls, use Data > Remove filter.

A filter view lets you set up a personal or named view without imposing that filtered display on everyone using the sheet. In the browser version of Google Sheets, open Data > Filter views and choose Create new filter view. Set the date condition in the filter dropdown, then use the filter-view controls to name or close the view. This is useful for a team that needs different people to examine different date ranges in the same table.

Use a standard filter when a shared, visible filter state is intended; use a filter view when collaborators need separate ways to inspect the same records. Neither method creates a separate copy of the data. If you need a durable report, consider copying the relevant results to a separate sheet or documenting the date boundaries used.

Filtering versus sorting by date

Filtering and sorting solve different problems. Filtering limits the visible rows to those matching a condition; sorting rearranges the rows in date order. From the date-column dropdown, Sort A to Z orders recognized dates from earlier to later, while Sort Z to A orders them from later to earlier. Sorting alone does not limit the table to a particular month or remove nonmatching dates from view.

If date sorting looks alphabetical or places some entries in unexpected positions, the column may mix true dates with text. Normalize the values before relying on either sorting or filtering. Also make sure the whole table is included when sorting, so names, amounts, and other fields stay attached to their original records.

Frequently Asked Questions

Can Google Sheets filter a column to one exact date?
Yes. Open the date column’s filter dropdown, choose Filter by condition, and select an exact-date option if available. You can also use Filter by values to select a listed date. If the expected rows do not appear, check for text dates or hidden time values.

How do I filter Google Sheets to show dates between two dates?
Choose Data > Create a filter, open the date-column dropdown, and select Filter by condition. Choose the between condition and enter the two boundaries. Verify records on both boundary dates, particularly if the cells contain timestamps.

Can I filter dates to show only this month?
Use a relative date condition if the condition menu offers the period you need. If you need a fixed calendar month or the relative option is not suitable, use a custom formula with a start date inclusive and the first day of the next month exclusive.

Why does my date filter show no results?
The cells may contain text rather than recognized dates, the date order may be misread because of locale settings, or the filter range may omit the records. Timestamps and incorrectly chosen boundaries can also exclude rows. Check a sample cell and the range before rebuilding the condition.

Will filtering dates delete rows or affect collaborators?
No. A filter hides nonmatching rows rather than deleting them. However, a standard filter changes the shared sheet’s displayed view; use a filter view when collaborators need to work with separate filtered views.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.