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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Program Due Date[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Lead Time
[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Order Date

[/TD]
[/TR]
[TR]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136, align: right"]9/15/2019[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136, align: right"]7/15/2020[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]57[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.