This was an interesting challenge that was requested of me. My client wanted a report that listed everything since the begining of the previous week, or everything since last monday. This is interesting because the date range changes, on monday it will be today()-1, on tuesday today()-2, etc. Using that pattern I came up with this:
The weekday() function gets 0 for Sunday, 1 for Monday, etc. So this will always get last week’s monday.