calculating working date between orderdate and due date

[wilkob]

I have a query in which I have a long list of orders and their entry date and due dates. I would like to calculate the number of working days between the both in order to see if the supplier keeps his theoretical delivery term.

Can some one give me a way to achieve this in my query:

DUE DATE.........ORDER DATE.........DELIVERY
03-03-2007 -/- 24-10-2006 = working days

many thanks in advance

 

[KeithG]

Try the below

DateValue(Format([Due Date],"mm/dd/yyyy"))-[Order Date]+1-(DateDiff("ww",[Order Date],DateValue(Format([Due Date],"mm/dd/yyyy")),7)-(Weekday([Order Date])=7))-(DateDiff("ww",[Order Date],DateValue(Format([Due Date],"mm/dd/yyyy")),1)-(Weekday([Order Date])=1))

 

[wilkob]

I just had to turn the days and months around (european date) and it works.

THANKS !!