Hi,
I pull data from a system which gives me an order date and a shipment date.
Thes data comes in this format:
Order Date Shipment Date
15/08/2012 17/08/2012
I want to return a '1' in another column for items that have been shipped within 4 days, and a '0' for items that haven't been shipped within 4 days. However, weekends don't count in the turn around time. For example, if the order was received on Wednesday 15/08/2012 and shipped on the Monday 20/08/12 this would only be 3 days, rather than 5 days.
Any help would be greatly appreciated.
Thanks
David
Bookmarks