Formula help - due dates falling on weekends

ksmith56491

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 

Paul Newcome

Have you tried using the WORKDAY function?

ksmith56491

How would I use WORKDAY in this scenario?  

Paul Newcome

=WORKDAY(date, number of days, [holidays optional])

 

Use it in the portion of your IF statement where you specify which date to display.