Details,
Column A: "In Dates" in the format dd/mm/yyyy
Column B: "Out Dates" in the same format
Column C: Calculates elapsed working days i.e using function NETWORKDAYS
All colums can have up to a years data which is used to calculate days taken to process certain documents, max, min, averages, sum etc conditional colour changes when over a certain number of days etc This is done a a seperate "Reports" worksheet. Some dates might appear more than once as several documents might either arrive or leave on the same day.
What I want to do is to be able to do is in the "Reports" worksheeet is have a cell for a "Start Date" and another for an "End Date" so as to be able to to extract the raw data for a given period.i.e. extract data from column c corresponding to the dates in column a "In dates" to and including the the corresponding end date in column a.

DOC IN DATE OUT DATE DAYS TAKEN A B C 1 12/05/2011 12/05/2011 0 2 13/05/2011 14/05/2011 1 3 13/05/2011 15/05/2011 2 4 14/05/2011 17/05/2011 3 5 14/05/2011 18/05/2011 4 6 15/05/2011 16/06/2011 32 7 16/05/2011 18/05/2011 2 8 17/05/2011 20/05/2011 3
i.e if I select "Start Date" 13/05/2011 and "End Date" 16/05/2011 it must extract data 1,2,3,4,32 & 2.



Thanks
Frustrated