Formula to show whichever is less

Options

Hello,

I'm working on a formula to show the remaining duration of a task. I'd like to calculate workdays using the planned end date minus either today or the planned start date, whichever is closer to the planned end date. For example, if the planned start date is 10/29/21 and the planned end date is 11/05/21, then the formula would calculate the remaining workdays between today and 11/05/21. However, if the planned start date is 11/05/21 and the planned end date is 11/12/21, then the formula would calculate the number of workdays between 11/05 and 11/12. I'm stumped on how to write this formula. Any ideas?

Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!