NETWORKINGDAYS

I have the following conditions:

1) Planned Ship Date (9-25-19)

2) Actual Ship Date (9-11-19)

If the Planned Ship Date = Actual Ship Date, Result should = 0

If Actual Ship Date < Planned Ship Date, Result should be a negative number (This should be -10)

If Planned Ship Date>Actual Ship Date, Result should be a positive number

Please advise on the formula

Regards,

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!