Printable View
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