I have a spreadsheet that contains several columns with project information. I want to modify:
=QUERY( 'Compilation'!A2:L; " select A, B, F, I, L order by A" ; 0 )
so it returns values in L that fall within a specific date range. The data ranges are located in specific cells — in this case P1 and P2.
I need to repeat the operation for different date ranges.
PS. Note that in P1 the cell contains the formula
=today() and P2