extracting a range of data between two date

newton.rogers

New Member
Joined
Aug 13, 2011
Messages
5
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 sometimes have a number of "In Dates" which have the same date and the same for the "Out Dates" i.e. the same dates make occur more than once.
The spreadsheet is used to keep track on a number documents coming in, being processed and then being sent out. We use this data to check numerous bits of information, how many documents we received, how long we took to process them and variuos other calculations such as average processing time, max & min processing time etc.
What I am trying to do is to be able to extract the data from column C for a certain period ie from a start date to an end date and then do the necessay calculations on the data extraced. Thanks - "Stumped
 
my email address is newton.rogers@sky.com. The version of excel is 2003 and this is what I require. The blue figures are the dates that are input, the red figures are the result. The other figures are the data that is already in the spreadsheet. Thanks in advance.

-- removed inline image ---
 
Upvote 0

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,224,537
Messages
6,179,408
Members
452,912
Latest member
alicemil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top