Forum Discussion
Solved
IF Statement with Networkdays
I'm trying to calculate workdays between two dates, but can we make it not to count starting date Example: I'm trying to count the day between 22/08/2023 - 23/08/2023 but the result always 2 days b...
Gumzz212 Well just put a minus sign in front of IF
=-IF(A2>B2,NETWORKDAYS(A2,B2)+1,AND(A2<>B2,WEEKDAY(A2,2)<6)*(NETWORKDAYS(A2,B2)-1))Had I known you real intentions from the start I probably would have taken a different approach, but this works as well.
Gumzz212 Well just put a minus sign in front of IF
=-IF(A2>B2,NETWORKDAYS(A2,B2)+1,AND(A2<>B2,WEEKDAY(A2,2)<6)*(NETWORKDAYS(A2,B2)-1))
Had I known you real intentions from the start I probably would have taken a different approach, but this works as well.
alternative would this work?
=NETWORKDAYS(A2,B2)+(2*(A2>B2)-1)*NETWORKDAYS(A2,A2)