Thunder Cat King
Thunder Cat King

Reputation: 662

Query function with date in Google Sheets

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')")

Upvotes: 0

Views: 1614

Answers (1)

Max Makhrov
Max Makhrov

Reputation: 18727

try:

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

Upvotes: 2

Related Questions