Hello ... I know this post is a little old, but I also had this problem and I saw it today. To make it clear:
Brianwarnrock's solution works fine as long as it's not Monday today. Then he would go back 1 week. James' solution is therefore more precise if you need "today" on a Monday and...