Forum Discussion
Solved
=NETWORKDAYS formula?
Hello people,
How do I use the =NETWORKDAYS and =IF formula together to add/substract ''1 day'' when the returned value is either <0 or >0?
For example:
If returned value from =NETWORKDAYS is -1, I want to display the value as 0 (I want to add ''1 day'' if <0)
If returned value from =NETWORKDAYS is 4, I want to display the value as 3 (I want to substract ''1 day'' if >0)
With dates in A1 and B1:
=(ABS(NETWORKDAYS(A1,B1))-1)*SIGN(NETWORKDAYS(A1,B1))
In Dutch:
=(ABS(NETTO.WERKDAGEN(A1;B1))-1)*POS.NEG(NETTO.WERKDAGEN(A1;B1))
2 Replies
With dates in A1 and B1:
=(ABS(NETWORKDAYS(A1,B1))-1)*SIGN(NETWORKDAYS(A1,B1))
In Dutch:
=(ABS(NETTO.WERKDAGEN(A1;B1))-1)*POS.NEG(NETTO.WERKDAGEN(A1;B1))
- Hartelijk bedankt Hans!
