Calculate Business Days Between Current Date and a dynamic field

[sdelacruz8]

Hi,

I am using CR XI and am wondering if there is a formula that calculates the Business Days (excluding the holidays and weekends) from Current Date to a date that is in a dynamic database field. I've seen formulas that calculates the business days, but you have to hard code the holidays.

Your help is greatly appreciated.

 

[IanWaterman]

I have only seen it where you either hardcode the holidays in the formula or you add a database table which holds the holidays ffor you. As part of your report you can then query that table and build and array of holiday dates that can be used within the above formula.

You pay your money and you make your choice.

Ian

 

[lbass]

Please do not crosspost in multiple forums. I responded in the other forum.

-LB