Formula help - due dates falling on weekends

10/31/18 Edited 12/09/19

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Have you tried using the WORKDAY function?

    thinkspi.com

  • edited 10/31/18

    How would I use WORKDAY in this scenario?  

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

     

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

    thinkspi.com

Sign In or Register to comment.