How to Filter Dates by Month in Google Sheets


Often you may want to filter dates based on month in Google Sheets.

Fortunately this is easy to do by creating a helper column and the following example shows how to do so.

Example: How to Filter Dates by Month in Google Sheets

First, let’s create the following dataset that contains information about sales made by some company on specific dates:

Now suppose that we would like to filter the dataset to only show the rows where the date is in January or March.

To do so, we must first create a helper column that contains the month number of each date.

Type the following formula into cell C2 to do so:

=MONTH(A2)

Then click and drag this formula down to each remaining cell in column C:

Next, highlight the cell range A1:C12, then right click and then click Create a filter:

Then click the Filter icon next to Month.

Then click Filter by values and then only check the values next to 1 and 3, which represent the months of January and March:

Once you click OK, the dataset will be filtered to only contain the rows where the date is in January or March:

Google Sheets filter by month

To remove this filter, simply right click any value in the dataset and then click Remove filter.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

How to Calculate the Difference Between Two Dates in Google Sheets
How to Add & Subtract Days in Google Sheets
How to AutoFill Dates in Google Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *