In my database, I've got a "modified_date," representing the last time someone modified that particular row. Let's say, for example, the date is 2021-05-09. That's a Sunday. I need the date of the previous week's Monday, Tuesday, Wednesday, Thursday, etc. so, Monday would be May 3rd, Tuesday would be May 4th etc.
I need the dates of the week associated with whatever date is in the "modified_date" column.
How would I do that?