Query function with date in Google Sheets

0
votes

I'm trying to return column M when the date matches the date in column I. Any idea why it says N/A when I run the query function? enter image description here

Here's the formula I'm trying to make work.

=QUERY(A2:M1000,"select M where(I='4/8/2016')")

1
sqlgoogle-sheetsexcel-formula
Here's a dummy data example spreadsheet for reference. docs.google.com/spreadsheets/d/… – Brit Gwaltney

1 Answers

2
votes

try:

=QUERY(A2:M1000,"select M where I=date '"&text(P1,"yyyy-MM-dd")&"'")