I have a dataset on Google Sheets similar to below:
I am trying to use the
query() function to return columns Name, Account and Date where Team equals one of the values listed in cell A1 in the format
Additionally, the value in Date column should be between the date in cell A2 (beginning, inclusive) and cell A3 (ending, inclusive.)
The results should be sorted ascending by date.