Display the prior "Monday" date from the following week

Rascal

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!

Leibel S

@Rascal

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))

Paul Newcome

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)

Leibel S

@Rascal

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))

Paul Newcome

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)