Working Days Date Diff

[wolverinec7]

prob a really easy one but i just can't think of it. for each customer a report is producing i have a subreport which tells them which date we were last on site. i can do a date diff to tell me its 30 days or whatever but i dont know how to say well 8 of those were weekends so its only 22 days.

any ideas?

 

[dgillz]

Ken Hamady has already tackled this one:

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

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?