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

Lead Time	Estimated Arrival
4 weeks	6 weeks	8/25/2016
10 weeks	12 weeks	10/6/2016

<tbody>
</tbody>

Thank you guys so much for the help!

 

[63falcondude]

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

	A	B	C
1	Lead Time Low (weeks)	Lead Time High (weeks)	Estimated Arrival
2	4	6	8/25/2016
3	10	12	10/6/2016

<tbody>
</tbody>

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.