How can I use a google sheet cell as reference instead of todate(now))
?
=QUERY('Task Data'!A:M,"select C, D, E, F, H, B, L, M where D < todate(now()) and G matches false")
You may try:
=QUERY('Task Data'!A:M,"select C, D, E, F, H, B, L, M where D < date '"&text(N1,"yyyy-mm-dd")&"' and G matches false")