Display the prior "Monday" date from the following week

Options
✭✭

A buyer asked that I create a sheet with a column to display the prior Monday "date" of a following week.

The goal is to set an automation triggered by the date in the "Reminder Date" column, to call the vendor on Monday to confirm the goods will be or have been shipped. I thought I would ask if this is possible before I attempt. I inserted the Weekday/Week/Year just to get me thinking...not sure if I will use.

I do have a sheet which displays 2023 beginning and ending dates for a Week #'s, which I use in another worksheet. Thinking the data might help me with my current project. Any thoughts are greatly appreciated!

Tags:

• ✭✭✭✭✭✭
Options

Not entirely sure if this is what you were asking. Try the below formula:

=[Earliest Due Date]@row - 7 + (2 - WEEKDAY([Earliest Due Date]@row))

• ✭✭✭✭✭✭
Options

So essentially the next upcoming Monday (or today if today is Monday)?

If the above is correct, this should work:

=[Reminder Date]@row + (2 - WEEKDAY([Reminder Date]@row)) + IF(WEEKDAY([Reminder Date]@row) > 2, 7, 0)

• ✭✭✭✭✭✭
Options

Not entirely sure if this is what you were asking. Try the below formula:

=[Earliest Due Date]@row - 7 + (2 - WEEKDAY([Earliest Due Date]@row))

• ✭✭✭✭✭✭
Options

So essentially the next upcoming Monday (or today if today is Monday)?

If the above is correct, this should work:

=[Reminder Date]@row + (2 - WEEKDAY([Reminder Date]@row)) + IF(WEEKDAY([Reminder Date]@row) > 2, 7, 0)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!