I need help calculating the number of days between startdate and enddate without accounting for the overlapping days. My data is as followed:
ID STARTDATE ENDATE N_DAYS OVERLAP
1 01-Jul-2000 07-Jul-2000 6.00 .00
1 01-Jul-2000 01-Dec-2000 153.00 1.00
1...