Need to count the total working days

[zingurs]

My table is as below:
Emp.name strt date end date netwrk days
A 1-Mar-16 10-Mar-16 8
B 6-Mar-16 10-Mar-16 4
C 8-Mar-16 12-Mar-16 4
D 16-Mar-16 26-Mar-16 8
Total Days 18

eg: Start date and end date of B is overlapping with A, so the total days worked by A & B is 8, means the days worked by A.

Similarly, i need the the total days worked by A, B, C, D. expected answer should be 18

[CAntosh]

Are you sure it's supposed to total 18? I'm counting 17. Person A worked 8 unique work days, B worked 0 unique days, C worked one unique work day (Friday March 11th), and D worked 8 unique workdays. Totaling 17 for me. I created a new column (column E) for unique workdays. I put the formula below in E2 and filled down. You can then create a SUM cell at the bottom of the column in E6.

Please Login or Register  to view this content.

[zingurs]

My bad....expected answer was 17 and the formual works perfectly as i need.

Thanks!!!