Hello all. I am trying to use the NETWORKDAYS formula to calculate two values:
1. Number of work days between order date and required date.
2. Number of work days between order date and invoiced date.
I do not want the formula to count the receipt date so I am able to get around this using something like
=(NETWORKDAYS(A2,C2))-1
Using this, 'Value 1' above is fine because orders are always required in the future. For 'Value 2' this also works if both dates are the same (0) or if the order is late and therefore a positive number.
The problem exists when the order is actually early and the invoice date is before the required date. In this case, the formula returns a value that is two days earlier than expected. How can I modify this so both numbers are correct? I have attached a sample workbook with some examples.
https://1drv.ms/x/s!AjtV5i3TBbxqg_IC2z05ZT0oVNEYxw
Thanks in advance for all comments and help!
1. Number of work days between order date and required date.
2. Number of work days between order date and invoiced date.
I do not want the formula to count the receipt date so I am able to get around this using something like
=(NETWORKDAYS(A2,C2))-1
Using this, 'Value 1' above is fine because orders are always required in the future. For 'Value 2' this also works if both dates are the same (0) or if the order is late and therefore a positive number.
The problem exists when the order is actually early and the invoice date is before the required date. In this case, the formula returns a value that is two days earlier than expected. How can I modify this so both numbers are correct? I have attached a sample workbook with some examples.
https://1drv.ms/x/s!AjtV5i3TBbxqg_IC2z05ZT0oVNEYxw
Thanks in advance for all comments and help!
