Working days between two dates - simply!

[NetBoulter]

Dear Community

I am very gnew ot this so whilst there are solutions on this page I simply cannot understand them. What I need to do is calculate the number of working days between two dates - even when the end date is before the start date. The context is: 

RFQDate is the date that the customer asks for the quotation

QTDate is the date we send the quotation

We have a KPI of 5 working days to send the quotation

If the customer asks for the quotation on Thur 24/11 and we send it on Tue 29/11 then this is 4 working days BUT

The formula to calc the diff between two dates will give more days because it counts the weekend

What simple column formula will give me the number of working days between the two dates? 

I dont understand functions or SQL very much so I need a really "numpty" explanation please. ManyThanks

[v-haibl-msft]

@NetBoulter

You should post in other forums but not Issues for need help topic. I’d like to provide following topics which already have right answers with detailed measure/column formulas to you. You should be able to get the final result just by following the steps in them.

https://community.powerbi.com/t5/Desktop/Number-of-working-days/m-p/22842/highlight/true#M7236

https://community.powerbi.com/t5/Desktop/calculate-number-of-working-days-between-2-dates/m-p/55456/...

https://community.powerbi.com/t5/Desktop/Calculating-number-of-days-between-two-dates/m-p/50073/high...

Best Regards,

Herbert

[BhaveshPatel]

Check out this Blog on PowerPivotPro.

https://www.powerpivotpro.com/2012/11/networkdays-equivalent-in-powerpivot/