How do I define work days

It's been a while - but what you can do is:
Count the number of days between the start and end dates ToDays(startdate - enddate)
Divide that number by 7.
Multiply by 4 to get the work days in whole weeks
Then you need to adjust for the number of days that remain that are work days for example;
if there are 10 days in the period, and the first day of the period is Monday.
Mo Tu We Th Fr Sa Su Mo Tu We
Then you have 4 work days  + Mo Tu We all of which are work days
So 7 total work days
Basically the adjustment is calculated as follows:
If the first date Mon
- If the number of remaining days is less than 7, add 3
- If the number of remaining days is less than 3, and all of them
...
That's the basic formula. 



------------------------------
Neil Schneider
------------------------------