Using IF with Networkdays

Hi All,

I am trying to calculate the number of days in SS and adding a clause that if the difference is greater than 45, it should return "No". If it is lower, it should return "YES".

Unfortunately, my code is not working, and I am stuck.

The formula I am using is the following:

= IF((NETWORKDAYS([Sent to NewOrder]2, [Sent to Billing]2)) <= 45, "YES", IF((NETWORKDAYS([Sent to NewOrder]2, [Sent to Billing]2)) > 45, "NO"))

Can someone help me, please?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!