I
iwtci
Good day to all of you out there?!
I work as a sales and marketing manager for a company selling an
installing elevators. I use a relatively large workbook to maintai
the database and control the delivery process, therefore, determin
when do I have to place the order with our principals, hence, forecas
the outgoing cash flow for this purpose only. yet, get a Gantt Char
of the expected workload for the installation dept. The primar
installation date is provided by our customer
I have the following setup for the sheet
A1 : data validation list to choose the year (2004 upwards)
B5:B20 contains the order number (manually entered)
C5:C20 contains the order quantity (manually entered)
D5
20 contains the delivery date (to be automatically calculated
i.e. I need help here.
E44 contains short month names (Jan, Feb, Mar…Dec)
A B C D E F G H
I J K L M N O P
1 2004
2
3
4 Order # Qty Del. Date Jan Feb Mar Apr May Jun Jul Aug Se
Oct Nov Dec
5 NA-092 3 to be calc
2 1
6 NA-097 7 to be calc
2 3 2
7 NA-101 3 to be calc
1 1 1
I work as a sales and marketing manager for a company selling an
installing elevators. I use a relatively large workbook to maintai
the database and control the delivery process, therefore, determin
when do I have to place the order with our principals, hence, forecas
the outgoing cash flow for this purpose only. yet, get a Gantt Char
of the expected workload for the installation dept. The primar
installation date is provided by our customer
I have the following setup for the sheet
A1 : data validation list to choose the year (2004 upwards)
B5:B20 contains the order number (manually entered)
C5:C20 contains the order quantity (manually entered)
D5
20 contains the delivery date (to be automatically calculatedi.e. I need help here.
E4
4 contains short month names (Jan, Feb, Mar…Dec)A B C D E F G H
I J K L M N O P
1 2004
2
3
4 Order # Qty Del. Date Jan Feb Mar Apr May Jun Jul Aug Se
Oct Nov Dec
5 NA-092 3 to be calc
2 1
6 NA-097 7 to be calc
2 3 2
7 NA-101 3 to be calc
1 1 1