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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!