I have four date fields and I'm counting business days aging (networkdays) for Aging 1 and Aging 2.
A B C D E F G H
1 Start 1 End 1 Aging1 Start 2 End 2 Aging2 overlap aging Overlap %
2 6/21/11 6/27/11 5 5/27/11 6/26/11 21 (4) (80%)
3 6/21/11 6/30/11 8 5/27/11 6/06/11 7 (0) (0%)
4 6/21/11 6/30/11 8 5/27/11 7/04/11 25 (8) (100%)
5 6/21/11 6/30/11 8 7/05/11 7/06/11 2 (0) (0%)
I need a formula that returns the ovelap Aging G2 and Overlap % H2. I'm filling this in manually and it's killing me. My main problem is that the fields don't always overlap and as illustrated above can stat and end at various times within each others process.
Thank you.
Bookmarks