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 i...
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))
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!
