Feb 23 2022 04:06 AM
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)
Feb 23 2022 04:11 AM - edited Feb 23 2022 04:18 AM
SolutionWith 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))
Feb 23 2022 04:11 AM - edited Feb 23 2022 04:18 AM
SolutionWith 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))