Removing weekend dates for a formula that calculates the number of days between 2 dates
Posted by gavin on May 08, 2001 3:03 AM
Can anyone please help me.
I have a formula which calculates if an order was received b4 15.00hrs whether it was shipped the next day and also if not whether it was shipped the following day from that!! ( Its used for SLA calculations)
Formulas as follows:
(Shipped next day for orders received b4 15.00hrs, formula gives me a 1 if ok.)
(shipped within 2 days of receipt, again gives a 1 if ok)
Currently it includes weekends, so does anyone know how to exclude them!
Many Thanks for all that have read this message this far!