How to Filter by Date Range in Google Sheets

To filter by date range in Google Sheets, you can use the "Filter" feature. Follow the steps below to apply a date range filter to your data:

1. Select the range of cells that contains the data you want to filter, including the header row.
2. Click on "Data" in the top menu bar.
3. Click on "Create a filter." This will add filter icons to the header row of your data.
4. Click on the filter icon in the header of the column that contains the dates.
5. Hover over "Filter by condition" and click on "Date is."
6. In the dropdown menu that appears, select the date range option that best fits your needs (e.g., "Before," "After," "Between," etc.).
7. Depending on the option you selected, enter the date(s) you want to filter by. You can either type the date manually or select it using the calendar icon.
8. Click on "OK" to apply the date range filter to your data.

Example

Let's say we have a dataset with sales data, and we want to filter the data to show only the sales that occurred between January 1, 2021, and March 31, 2021. The dataset looks like this:

Date        Product  Revenue
01/02/2021  A        1000
02/05/2021  B        1500
04/15/2021  C        2000
01/15/2021  D        1200
03/08/2021  A        900

Follow the steps mentioned above:

1. Select the range A1:C6
2. Click on "Data" in the top menu bar.
3. Click on "Create a filter."
4. Click on the filter icon in the header of the "Date" column.
5. Hover over "Filter by condition" and click on "Date is."
6. Select "Between" from the dropdown menu.
7. Enter "01/01/2021" as the start date and "03/31/2021" as the end date.
8. Click on "OK."

The filtered dataset will now look like this:

Date        Product  Revenue
01/02/2021  A        1000
02/05/2021  B        1500
01/15/2021  D        1200
03/08/2021  A        900