Lead Time Formula

[Cajuns2009]

Hello Everyone!

I could use some help figuring out a way to make a good lead and easy lead time formula. Long story short, If I am ordering a piece of fabric and the lead time is 10-12 weeks. I would like to be able to insert 10 to 12 weeks, and excel show me the dates that would fall under for real time. I was thinking of using something like the =networkdays but I am just to confused. I would like it to make sure the dates don't fall on weekends or holidays if that is possible,

So for instance today being 7/14/16

[TABLE="class: grid, width: 274"]
<tbody>[TR]
[TD="colspan: 2"] Lead Time[/TD]
[TD]Estimated Arrival[/TD]
[/TR]
[TR]
[TD]4 weeks[/TD]
[TD]6 weeks[/TD]
[TD="align: right"]8/25/2016[/TD]
[/TR]
[TR]
[TD]10 weeks[/TD]
[TD]12 weeks[/TD]
[TD="align: right"]10/6/2016[/TD]
[/TR]
</tbody>[/TABLE]


Thank you guys so much for the help!

 

[63falcondude]

Let's say you set up a table like this:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Lead Time Low (weeks)[/TD]
[TD="align: center"]Lead Time High (weeks)[/TD]
[TD="align: center"]Estimated Arrival[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]8/25/2016[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]10/6/2016[/TD]
[/TR]
</tbody>[/TABLE]

C2 =TODAY()+(B2*7)

Does this work for you?

Edit: This doesn't take into account weekends or holidays.

 

[63falcondude]

Try C2 =WORKDAY((TODAY()+(B2*7))-1,1)

Source: https://exceljet.net/formula/next-business-day-6-months-in-future

Note that you will have to make a list of holidays if you want to take them into account in your formula.