I have created a PivotTable with datas looking like the following, i could
only manually pick out the first date received and the last date out, and sum
the no of networkdays, however it involves a lot of work since there are many
companies, wonder if anyone has a better idea. Thank you very much!

Company Date Received Date Out No. of Networkdays
ANY 10/12/2005 12/12/2005 0
12/12/2005 13/12/2005 1
15/12/2005 16/12/2005 1
BEG 02/12/2005 05/12/2005 1
05/12/2005 07/12/2005 2
08/12/2005 09/12/2005 1
12/12/2005 13/12/2005 1

The final result should look like
ANY 10/12/2005 16/12/2005 2
BEG 02/12/2005 13/12/2005 5