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

Hi

It would be easier if you are able to post a sample spreadsheet then we could look at what you need.
Tony(OTPM)

Please find a copy of the spreadsheet attached, the cells H2 to J9 is the result of populating cells E2 and F2. Hope you gather the layout, columns D and G are only for spacing.

A B C D E F G H I J 1 In Date Out Date NetWorkdays Start Date End Date In Date Out Date NetWorkdays 2 15/08/2011 18/08/2011 4 15/08/2011 28/08/2011 15/08/2011 18/08/2011 4 3 15/08/2011 22/08/2011 6 15/08/2011 22/08/2011 6 4 19/08/2011 29/08/2011 7 19/08/2011 29/08/2011 7 5 20/08/2011 25/08/2011 4 20/08/2011 25/08/2011 4 6 23/08/2011 01/09/2011 8 23/08/2011 01/09/2011 8 7 24/08/2011 27/08/2011 3 24/08/2011 27/08/2011 3 8 27/08/2011 05/09/2011 6 27/08/2011 05/09/2011 6 9 28/08/2011 02/09/2011 5 28/08/2011 02/09/2011 5 10 31/08/2011 04/09/2011 3 11 31/08/2011 06/09/2011 5

The figures in black is the exsisting data, the figures in blue the dates for for which I want the corresponding data for and the red figures is the data that it should produce.

Hi
No spreadsheet attached.
Tony (OTPM)

The figures in black is the exsisting data, the figures in blue the dates for for which I want the corresponding data for and the red figures is the data that it should produce.

tell us which column letter contains the black and which column letter contains the blue.

Columns A - "In date" B - "Out Date" & C contains the the "Networkdays",
column d is a gap column, column e is the Start date column and column f is the End date column, column g a gap column and columns H, I and J the returned data. I hope this makes sense. I have got a little further in solving this by using advanced filtering but is there any other method one could use by only using formulas?