Google Sheets QUERY - Filter by Date Range using WHERE Statement Tutorial - Part 3

Video tutorial series about QUERY function in Google Sheets.

In this tutorial we'll cover how to use QUERY function in Google Sheets to pull filtered results within a specific date range.

Google Sheets

Website:

[TraucoATL]

Your channel has been a career-saving resource ever since I first stumbled upon it four years ago... I have spent the last three days stuck on fixing an issue with the dynamism of a workbook I am building in G Sheets; I searched your channel before starting this project but couldn't fine a resource to do what I was trying to do...

This video gave me an eloquent solution to the problem, thank you!

[justfly]

I can't possibly explain how helpful these videos are. The way you teach is perfect! Don't change a thing.

[qgdkojy]

Hey, guys! Working method in the next video! It`s something like
="SELECT A, C, D, E, F, I WHERE A >= date '2019-07-07' AND A <= date '2019-08-17'"


Yeah, author, thanx 4 your videos! I like it so much! But, it will be better, if you shared with your spreadsheets, please!

[ramouuuu]

Gosh I love youtube and I definitely love you 😍

[dougjohnson]

Thank you. Your tutorials are awesome. So clear and easy to follow.

[adaezeopara]

Really helpful. thanks. This tutorial helped me solve a problem which plagued me for days.

[thoa]

Super easy undertanding, thanks for the clip

[juanpauloalmazan]

what about for Time? Do i need to use the text formula or just normal operation?

[yboulais]

You guys are so good, thank you so much for sharing these videos.

[nurcahyakusuma]

Can we use formula like "select E F D where D =A2" ?
I mean, A2 is the example value where I search using vlookup. For example, the result in A2 in my sheet is the specific date I want to look up

[hugomac]

Wow I have been looking every where for this video thank you thank you

[Hermiel]

There's no need to convert the date to a number. You can prefix your date with 'date' in the query string itself.

[mdatiqurrmolla]

Well I have just tried to use the filter in the date column selecting condition "is between" and then entered 2 dates in the same format as in the cells and it just works like a charm, so I guess google has updated the support for it.

[Mrchuy]

I don’t get an error on mine but It doesn’t retrieve the data except for the header

[jacksonbmx]

Aula perfeita!!! thx man!!! Me economizou células e pude acrescentar mais dados na planilha que eu tinha feito. Pena que só pode ser usado 5 milhões de celular por spreadsheet. Eu precisava de 3 vezes desse valor. Mas uso outras spreadsheet para juntar as base de dados.

[hammockmonk]

These videos are very useful to me, thanks. Subbed!

[mayurrajude]

Please Provide a Data Set Whenever Make a Tutorial For Practice it helps to Understand

[joensleygarcia]

I have been trying to do this function multiple times and it doesn't work at all. I wonder

[officeoffamilyandcommunity]

Thank You +Learn Google Spreadsheets for this series!

[hunterholeman]

I could be wrong, but this information may no longer be correct (as of 5/24/2024). When following the instructions outlined in this video, it didn't work.

This is an example query that did work: select B, F where F = date '2015-01-08'. Instead of using date as a number, you need to include "date" and enter the date with 'YYYY-MM-DD" format.