Calculate Date Difference but Business Days Only

[lborja]

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,

[JohnTopley]

Try

=(NETWORKDAYS.INTL(A2,B2,1))+IF(SIGN(A2-B2),SIGN(A2-B2),-1)

A2=Due Date
B2=Arrival Date

..... without Holidays

[lborja]

it almost worked but it gave me the opposite, if it was 1 day early, I would like to see "1" and if it was 1 day late, I would like to see "-1"

Thank you!

[JohnTopley]

Try

=((NETWORKDAYS.INTL(A4,B4,1))+IF(SIGN(A4-B4),SIGN(A4-B4),-1))*-1

[lborja]

the formula is not going through with the *-1 at the end of it.. I am getting the prompt "we found a problem with this formula..."

[JohnTopley]

Works OK for me: Did you Copy/Paste from the thread? Check brackets.