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 because the starting date is counted
how to make the starting date is not counted?
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.
- hey could you help me, i try to use the -1 but when the progress start and end at the same day it always resulted -1
To exclude the first day from the count, I would go for Riny_van_Eekelen 's first formula
= NETWORKDAYS(initialDate+1, finalDate)
