Date Formula for the Monday following a Date

Emilie Nichols

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!

Andrew1983

https://community.smartsheet.com/discussion/26476/automatically-populate-monday-before-existing-date-in-sheet

I actually just had the same issue, but I needed the previous monday.

=IF(ISDATE(Date@row), IF(WEEKDAY(Date@row) = 1, Date@row - 6, Date@row - WEEKDAY(Date@row) + 2))

Make sure your column property is set "DATE" or else you'll get an "invalid column value" error.

I was going to say you need two columns to do this but I see now you're using the "confirmation date" as your actual date and then you will have your calculated Monday date in your "schedules due" date.