Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 =today() and P2 = P1+14.

share|improve this question
Please share a doc with us. – Jacob Jan Tuinstra Feb 9 '13 at 21:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.