Filter Your Data by Month in Google Sheets

In this video, you learn how to filter your data by selecting a month from a dropdown list in Google Sheets.
You will learn two different methods to accomplish this task.

PRACTICE FILE
Download the sample file used in the video.

RESOURCES

LEARN EXCEL OR GOOGLE SHEETS
- Google Sheets Masterclass: Coming soon...

VIDEO CHAPTERS
00:00 - Intro
00:16 - Ex 1 Setup
00:49 - Ex 1 Dropdown List
01:44 - Ex 1 Formulas
02:59 - Ex 2 Setup
03:23 - Ex 2 Dropdown List
03:51 - Ex 2 Formula
04:45 - Conclusion
05:07 - Outro

[ASADREHMAN-fd]

Thanks so much for valuable information, i make my sheet last year 2023 but now in 2024 if choose march 2024 it filter data of march 2023, how i can fix it ?

[KunalDey-jk]

My database format example is 22/04/24
And you show the example date format 22-jan-24

Please help me to make the sheet

[FarhanAbdullahi-fo]

This is very useful, but what if my data contains different months with different years, and i just need specific month of specific year?

[ryanlindsey]

Excellent video, thank you! Also love how you're using the mouse to select cells for the input, since that's often something I find confusing and frustrating when I'm trying to close a pop-up, and it enters the cell data for me.

[mrsnkf]

hello, i want to ask, How to filter with two criteria (e.g: month and category)? thank you

[san]

how to create filter for month and we want to know the total amount for that month?

[meaganlong]

With practice from this video and from the Excel one, I feel like an expert in the FILTER function now! Thank you for your great explanations and great examples!

[yaqin]

Hello i;m from Indonesia. Thank you for sharing this tutorial. How about if i want to filter month from january to march?

[momsheees]

Hi, thank you for sharing. would like to know if there is a way to filter the year and the total amount as well? would appreciate your response.

[winnerscirclenissan]

How can I link the month filter to show for both sides at the same time? In other words, when I select the month of February the source data also filters the other months and only shows the month of February?

[vernavong]

hello, this is for 12 month, now about next january 2024 ? how to count more

[hfrzflq]

Hello there! Great explanation and simple example. But can you help me how to count how many data in each month as a quantitative number? For example, in April only 4 data input. In May only 6 data input.

Thanks

[kishoresivamaniraj]

hey i need a help i just want to know is it possible to filter the source data directly rather than creating another table please help me if anyone know

[aabdullahhaasnain]

You have one year data. What if there are multiple years data?

[abhilashm]

Hi I followed all the step you said
But last I got message error.

[alfo-klys]

what about if there is "ALL" in the dropdown list

[wslim]

what can i do, if i just want to take source date Col H and J

[ReetardM]

Thanks for this effective example. Is there any way to use 01.01.2000 format rather than using 2-Jan-2023 style?

[pakiatanonlinecoachingcenter]

Can source data taken from another sheet?

[Moon-bnez]

2:36 it says #Value!, what should I do with it? The details don't appear. Thank you