Calculated date that doesn't fall on weekend but next week day

Jeana ✭✭✭✭✭✭
edited 04/16/20 in Formulas and Functions

I have a date field (Date to be Completed) where I calculate so many days before or after a "Course Launch Date". I need to make sure that if that calculation lands on a weekend it automatically advances to Monday. Here's the steps, just can't figure out the formula.

Course Launch Date: (PARENT): 5/26/20

Date to be Completed: =(PARENT([Course Launch Date]@row) + 12)

This formula results in a Sunday: How can I make it land on Monday if it's on a weekend? Or if needed - Land on Friday if it's Saturday and land on Monday if it's Sunday?


Best Answer


  • Jeana
    Jeana ✭✭✭✭✭✭

    Yes!!! Thanks so much. Don't know why I couldn't come up with that formula.

    Thanks so much!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. 👍️