In this tutorial, you will learn how to filter by a given date range in Google Sheets
How to Filter by Date Range in Google Sheets
If you have a dataset that contains dates, you might need to filter the data by a certain date range. For example, you may want to see all the data from the past week, month, or year. Or, you may want to select all transactions made in the first quarter of a certain year.
Fortunately, Google Sheets makes it easy to filter data by date range. We can use the ‘Filter by condition’ option to set up a filter that selects data with dates between a specified start and end date.
In this guide, we will show you how to filter data by date range in Google Sheets.
How to Filter a Column Given a Specific Date Range in Google Sheets.
Here’s how to filter a column given a specific date range in Google Sheets.
First, select the column that contains the date data.
In the example above, we’ll use the transaction_date field to filter our date by a date range.
Click on the Create a filter function under the Data menu.
The selected column should now have a filter icon in the column header.
Click on the filter icon to reveal the filter options. Click on the section labeled ‘Filter by condition’ to reveal the additional options.
Select ‘Is between’ in the dropdown menu.
Specify the start date and end date in the two provided text boxes. Click on OK to continue.
You should now have a filtered range that excludes data that fall outside the specified date range.
Alternatively, we can create a new table where the user can specify the date range themselves.
Instead of typing the date values directly into the filter options, we’ll use cell references to the external table.
This guide should be everything you need to filter by date range in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to filter in Google Sheets:
- Create Multiple Filters
- Create A Filter
- Create A Filter View
- How To Filter
- How To Create & Use Filter Views
- Filter By Multiple Conditions
- Filter By Color
- Filter Not Working (How To Fix)
- Filter Unique Values
- Filter Duplicates
- Filter Google Sheets Only For Me
- Extend Filter Range
- Filter Charts Using Slicer