Delivery lead time formulas

[lokujo12]

Hello
I am in dire need of some assistance. I am trying to create a order schedul
an
anticipated delivery schedule
I have my columns set by week. (6/21/10,6/28/10, etc) I would like to enter i

numerical value in my "order schedule" (100,200,etc) and have th
numerical value populate the "delivery schedule". Most my lead time
will be calendar days..I would like to understand both options of calenda
day
and work days...if possible :

My issue is if we place the order "week of 6/21/10" o
"100&quot
the order could be ordered on 6/21/10 or 6/25/10 so it anticipated deliver
dat
could fall on 2 different weeks or on the weekend
I am happy to estimate the worst case scenario (order placed at the end of th
week 6/25/10
SO can I enter a formula in my "delivery schedule" to pull numerica
data from my "Order schedule" and have the numerical value populat
the week it will arrive

Right now I did it manually. Example: For week of 6/21/10 (on order schedule

enter in "100" and it populates week of 9/20/10 (delivery Schedule)

note: I added my lead time (90 calendar days) to the week end date of 6/25/1

This is OK but if I can find a better formula that would be great. I know th
lead times will change so it would be nice if I didn't have to manually g
bac
and to the math and adjust the cell format. So if I change lead times it wil
automatically adjust the delivery schedule

I hope someone understands what I am looking for and can help! Hopefully
didn't anyone to sleep

Any advice would be greatly appreciated

Thank
Nick

 

[Don Guillett Excel MVP]

Hello,
 I am in dire need of some assistance. I am trying to create a order schedule
and
 anticipated delivery schedule.
 I have my columns set by week. (6/21/10,6/28/10, etc) I would like to enter in
a
 numerical value in my "order schedule" (100,200,etc) and have the
 numerical value populate the "delivery schedule". Most my lead times
 will be calendar days..I would like to understand both options of calendar
days
 and work days...if possible

 My issue is if we place the order "week of 6/21/10" of
"100"
 the order could be ordered on 6/21/10 or 6/25/10 so it anticipated delivery
date
 could fall on 2 different weeks or on the weekend.
 I am happy to estimate the worst case scenario (order placed at the end of the
 week 6/25/10)
 SO can I enter a formula in my "delivery schedule" to pull numerical
 data from my "Order schedule" and have the numerical value populate
 the week it will arrive?

 Right now I did it manually. Example:  For week of 6/21/10 (on orderschedule)
I
 enter in "100" and it populates week of 9/20/10 (delivery Schedule)
-
 note: I added my lead time (90 calendar days) to the week end date of 6/25/10

 This is OK but if I can find a better formula that would be great.  I know the
 lead times will change so it would be nice if I didn't have to manually go
back
 and to the math and adjust the cell format. So if I change lead times it will
 automatically adjust the delivery schedule.

 I hope someone understands what I am looking for and can help! Hopefully I
 didn't anyone to sleep!

 Any advice would be greatly appreciated!

 Thanks
 Nick

"If desired, send your file to dguillett @gmail.com I will only
look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."