Formula help - due dates falling on weekends

I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays.  Now, I want to move those dates to the Monday next.  Is there a way to automate that?  Ultimately, I need the best way to calculate due dates but that will move them to the next business day either automatically, or alert me and allow me to move them.  I've included a screenshot and provided all the relevant columns and formulas.  

Your help is appreciated!  Thanks in advance! 

Kimberley 

Screenshot1.jpg

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!