calculation only with workdate

[#1]

Dear all,

at the moment I have the problem that I want to calculate our deliveryquote.

My biggest problem is, when we get new orders on friday, we have no chance to deliver this order on Monday, but

in calculation I say order date - delivery date and there I get 3 days, but we have deliverd it at 1 day.

So have I any chance to say, that I only want to calculate with the workdate?

Thanks a lot of help

Best regards

Björn

[Anil_Babu_Samineni · Accepted solution]

Would you provide Excel and expected o/p

[sunny_talwar]

May be using NetWorkDays() function

http://www.learnqlickview.com/qlikview-functions-networkdays/

networkdays ‒ QlikView