Date Formula for the Monday following a Date

I'm looking for a formula or automation that calculates the date of the Monday following a specific date. The initial date may be a Tuesday, Wednesday, or Thursday, but the date I need to "fill in" will always be Monday, as it's a due date. In the example below, the Schedules Due Date column needs to be the Monday after the date in the Confirmation Date. Any ideas? Thanks in advance!


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!