Hello,

I'm a AIT Instructor and i need a formula for specific date to be 4 weeks in the past and land on a Monday. so if it is 27 Nov 13 the value date needs to be 28 Oct 13. The students have to take a test 4 weeks before graduation and it has to be on a Monday.

Thanks

V/R
SGT Roy, Adam