Forum Discussion
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 See if the attached file contains the solution you seek.
yes, but how we make the date before deadline is the minus one
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.
