I have a spreadsheet (URL below). I've set up a query to make sure I understand how to do a query with a date range. Then I tried to create a similar query on the "real" data. The "Week 1" worksheet feeds the "Week 1 data" worksheet, where I manipulate the data and it contains the query. The data range query returns no results. All other queries work.
Google Sheets – Query Using Date Range Not Working
formulasgoogle sheetsgoogle-sheets-arrayformulagoogle-sheets-datesgoogle-sheets-query
Related Topic
- Google Sheets Query – Specific Values Based on Date Ranges
- Google Sheets Query with Date and Time
- Google-sheets – Filtering a QUERY using MATCH – how to pass column value into function? Or is there a better way
- Google Sheets Query – Date Formatting Guide
- Google-sheets – Using Google Sheets cell reference in SOQL Query
- How to Extract Day of the Month from Date in Google Sheets Query
- Google-sheets – How to populate a cell based on specific name and specific date using a query function
- Google Sheets – Insert Query into Specific Cell Based on Dynamic Reference
Best Answer