Date calculation formula

[onemikekelly]

Hi

I am trying to calculate how long it takes a supplier to send an incident report excluding weekends (column J) using columns E and F for the formula. As the supplier doesnt have office staff working on weekends these should be excluded from the calculation.

For example on row 2 the formula i have used is =NETWORKDAYS(E2,F2), this should give a result of 0 as it was on the same day, row 3 should be 1 day and row 4 should be six days.

My formula seems to be including the date in column E as day 1 wheres this should be day 0.

Can anyone help with this please.