SOLVED

=NETWORKDAYS formula?

Copper Contributor

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)

2 Replies
best response confirmed by PAtesting (Copper Contributor)
Solution

@PAtesting 

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!
1 best response

Accepted Solutions
best response confirmed by PAtesting (Copper Contributor)
Solution

@PAtesting 

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))

View solution in original post