(senddate - orderdate) -- without counting the weekends

[Anonymous]

I'm looking for an expression to calculate the turnaround days for a repair without counting the weekend days.

I have two date fields order date and send date.

What I'm looking for is a sum of send date - order date ... seems easy but I don't want the weekends to be in the calculation

For example:

order date 11/11/2009
send date 11/18/2009

The result should be 5 instead of 7

order date 9/8/2009
send date 11/16/2009

The result should be 49 instead of 69

Anyone got suggestions??

[#2 · Accepted solution]

Hi,

look for NETWORKDAYS. I hope you are now a step closer to your solution.

Good luck!

Rainer

[Anonymous]

Thx ... didn't know the function yet.