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