Subtract 5 days from maturity date but exclude weekends

[OT2]

Hello,

Using CR11 to put together a report that shows fixing dates for notes, for example, a gold note that expires on 07/15/05 would have a fixing date of 07/08/05, ie: 5 business days prior to the maturity.

Simple subtraction in CR11 would provide me with a fixing date of 07/10/05, which is a Sunday and is wrong. Any suggestions on whay kind of formula I can use to calculate fixing dates, (maturity date - 5 business days).

I have looked at

http://www.kenhamady.com/form01.html

and a few other threads out there but can't really make those formulas apply to what I need.

Appreciate any help you can provide.

Thanks,
OT2

 

[OT2]

Never mind, found solution at

http://www.kenhamady.com/form17.html