Display the prior "Monday" date from the following week

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!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!