Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.