Count Weekdays Between Two Days
Posted on 2004-09-01
I have a column with an order date, a column with a shipment date and a column that calculates the number of days between the two dates. Now I need a new column that calculates only the number of business days (M-F) between those two dates. For example.
ORDER DATE SHIPMENT DATE DELTA IN DAYS DELTA IN WORK DAYS
6/2/2004 6/14/2004 12 8
6/25/2004 6/29/2004 4 2
7/3/2004 7/4/2004 1 0