Calculate future date according to criteria met but only workdays

Hi! I'm using this formula:

=IF(ISDATE(Date@row), IF(Level@row = "1", (Date@row + 2), IF(Level@row = "2", (Date@row + 3), IF(Level@row = "3", (Date@row + 4)))))

With each level there'll be certain criteria:

Level 1 = 2 days

Level 2 = 3 days

Level 3 = 4 days

The formula is actually correct but it includes weekends. Therefore I would like to include the WORKDAY formula but couldn't find the right way to match them as I only want to calculate our working day.


Thank you in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!