Crystal formula to exclude weekends?

[hermes418]

I have a client that is pulling a monthyl Crystal report that checks variance between the date an order is entered and the date an order is shipped via a simple subtraction formula. The client wants to change the report so that weekend dates are not included in the calculation--I don't think it is possible, but does anyone have any ideas?

 

[synapsevampire]

Here's a blurb on doing this in Crystal:

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

I opt for using a Periods table which is more complicated to design initially, but here's a link to my FAQ:

faq767-4532

-k

 

[synapsevampire]

Also check this FAQ:

faq767-5430

-k

 

[2BATech]

I know that Access will be able to solve your problems.