Calculating Business Days between Current Date and a Dynamic field

[sdelacruz8]

Hi,

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

Your help is greatly appreciated.

 

[lbass]

Since holidays change from year to year, I don't think there's a way of getting away from coding them at least once per year. Try Ken Hamady's formula:

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

-LB

 

[Madawc]

Or you can create a dataset that holds such holidays entered as data, if you can change the database.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10