I'm using CR version 9. Based on the curent date at the time of running the report, using a formula I would like to calculate the date for the Monday of the equivalent week to the current week a year ago.

For example using Thursday 18th August 2011, I would want it come up with Monday 16th August 2010.

 

Thanks for any help.