Hello!

I previously requested assistance to calculate the number of days between two dates which is working great, I have since added another column (H) which contains a "Yes" or "No" value and I would like the formula to calculate days if H2 = "No" and put a zero value if H2 = "Yes"

The formula which is currently calculating the number of days is this;

IF(K2=M2,0,NETWORKDAYS(K2,M2)-1)

Thank you in advance.