Formula for Parameter With Date Range Without Weekends/Holidays

[Jtreshan]

I'm working on a report in which I need to select records for items which are in my facility for work. I need to establish a parameter with which I can select a range of dates and then calculate how many days an item has been in the facility, without counting non-work days (weekends and holidays). I do not have access to the
NextNBusinessDays function in my version of Seagate Crystal Reports (if so, I would have started with that, and then tried to figure out how to account for the holidays).
Any ideas for a formula that will work?

 

[MalcolmW]

For a method that works with any version of SCR,

http://support.seagatesoftware.com/CommunityCS/TechnicalPapers/scr_businessdays.pdf

Malcolm

 

[kenhamady]

For another version, see the FAQ on common formulas. This also allows you to add a list of holidays, but that section can also be deleted. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal