Lead Time Calculations

[cont4gious]

I can't seem to figure out a formula for this. Please help! I want it to count business working days in numerical output for when I should Order the part based on the date I open the excel file compared to Due Date with Lead Time.

A	B	C
Program Due Date	Lead Time <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> </tbody>	Order Date
9/15/2019 <tbody> </tbody>	25
7/15/2020 <tbody> </tbody>	57

<tbody>
</tbody>

Thank you so much!

 

[Special-K99]

Not sure I understand this, simple as though it looks.

Isn't the date you open the Excel file immaterial?
Surely you just want (Program Due Date - Lead Time) ?
In which case

=WORKDAY(A2,-B2)

You might want to add a list of holiday dates as well that you want to avoid.