Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Date Computation.
I'm working with a spreadsheet for product deliveries.
Each entry has a field for a 2-letter Port of Departure Code (POD) in column G, Factory Departure date (H), and arrival to Distribution Center Date(K) After entering the POD code (there are 30 possibilities) and the Factory date, I look at a chart that contains # of transit days from each POD to the DC, then in column k " = (click on date in H)+ (# of days from chart)" which gives me the date to the Distrib Center. Can I set it up so all I need to enter is the POD and factory date and the DC arrival date is entered automatically? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Date Computation.
Create a table that contains the POD and # of transit days.
Use the vLookup function (see HELP for details) to add the transit days for that POD to the Factory Date. HTH, Gary Brown "JayD" wrote: I'm working with a spreadsheet for product deliveries. Each entry has a field for a 2-letter Port of Departure Code (POD) in column G, Factory Departure date (H), and arrival to Distribution Center Date(K) After entering the POD code (there are 30 possibilities) and the Factory date, I look at a chart that contains # of transit days from each POD to the DC, then in column k " = (click on date in H)+ (# of days from chart)" which gives me the date to the Distrib Center. Can I set it up so all I need to enter is the POD and factory date and the DC arrival date is entered automatically? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percentage computation | Excel Discussion (Misc queries) | |||
computation error | Excel Discussion (Misc queries) | |||
Time Computation | Excel Discussion (Misc queries) | |||
What type of pc is best for computation | Excel Discussion (Misc queries) | |||
Help wanted with computation | Excel Programming |