I use query to extract two columns from another sheet with data.
- Column A has dates
- Column B - numbers
I want to extract only rows that correspond to a specific calendar week number. For example 19. I use this query
=query(Database!A1:AD,"Select A,AB where WEEKNUM(A)=19",1)
But it returns
#VALUE error. What is wrong?