stripping out bank holidays

[wolverinec7]

hi everyone, has anyone ever had to count up/strip out bank holidays from a report. i've built one that workds out working days betwen 6 dates.

for example every case will have an open date, first call date, first seen date, last seen date and a couple of others in between and my report works out how long they waited for each stage and they want to minus off any holidays

thanks

carl

 

[kenhamady]

This formula might help:

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

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/