Hi All,

I am trying to calculate the days between two dates, but only counting business days (Monday to Friday, holidays not counted if possible)

For ex.) A file has a Due Date of 3/21/16 (Monday) and Date Arrival is 3/23/16. I want to see that this file was late by 2 days (or show a -2) . If the file came on 3/21/16, then it came on the same day so I would like to see a 0.

In addition, if the file has a due date of 3/25/16 (Friday) and Date Arrival is 3/23/16, then I want to see that it arrived early by 2 days (or show a +2)

I tried using NetworkDays in my formulas, but it would only work if the file was late or early but can't calculate properly for both.

Any ideas you guys might have would be appreciated!

Thanks,