Holidays AND Weekends

[quixote]

I have two fields, OrderDate and ShipDate. I want to calculate the number of days between these two dates. However, I want to Subtract Weekends and Holidays from this total. I have a Holiday table in the DB. Does anyone have a suggestion on the best way to accomplish this?..I have VB6 and Access97....thank you

Maybe I'm missing something here, but:

Date1-Date2 = X days

X\7= Y Weeks (Note the integer division)

2*y = Z Number of week days

X - Z = number of work days

Now subtract off the holidays and you have the number of
work days.

You'll also have to check the remainder days (X - (Y*7)) to
see if a Sat or Sunday is included.

Good Luck
DerFarm