IF, dates and values

[lokujo12]

Hello
I am looking to enter values in a "delivery schedule" and have
separate "when to order" schedule below that will automaticall
populate a few weeks back (taking into account the necessary lead time
Right now I have them set up in the same worksheet something like below

a b c d e
1 Delivery schedul
2 21-Jun 28-Jun 5-Jul 12-Ju
3 material lead time (days
4 abc 7 10
5 efg 7 20
6 hij 14 30

8 Order schedule 21-Jun 28-Jun 5-Jul 12-Ju
9 materia
10 abc 10
11 efg 20
12 hij 30

However I want to be able to enter data in the delivery schedule and have tha
value(quantity) date back the lead time and fill the order schedule
If someone could help identify the formula to enter in each cell in the orde
schedule that would be great
Thanks in advance
I would be happy to provide a sample file..if that helps
Thank
Nick

 

[Stan Brown]

However I want to be able to enter data in the delivery schedule and have that
value(quantity) date back the lead time and fill the order schedule.

I don't understand your table, but if your lead times are calendar
days, the formula for the "order date" cell is simple:

= (delivery date) - (days lead time)

Just be sure to format the cell as a date.