Exclude Sat/Sun in Days Calculation
Posted on 2000-04-03
I have an Access dbase for order shipments set up with a table that includes the NeedByDate and ShipDate. I need to calculate the number of days each shipment is early/late based on those 2 dates, but, I want to exclude Saturdays and Sundays in the calculation. How can I accomplish this?
Example: NeedByDate=4/7/00 and ShipDate=4/10/00, then shipment was only 1 day late, since sat/sun aren't included.