I have a spreadsheet that contains several columns with project information. I basically want to modify the following formula:
=QUERY( 'Compilation'!A2:L; " select A, B, F, I, L order by A" ; 0 )
So that 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
P2 = P1+14.