Help

[Aj80]

I am trying to make an ETA sheet in excel for a transport company...I need to make 2 colums as below.

1st column needs to have Departure date. If the country mentioned in column B is for example Norway then departure for Norway is on Tuesday and Friday. So if Loading date mentioned in Column D is 1st December then depature should be Tuesday 3rd December. If the loading date for Norway is 4th December then departure date should be 6 December Friday.

There are other countries which have similar departure dates.

2nd colum needs to have the ETA which will be based on this Departure date. for eg transit time for Norway is 5 working days and departure date is 3rd December then ETA should be 10th January.

Any suggestion is appreciated.

 

[ranman256]

1. have a table for the county and working days.
2. then user enters the depart date,
grab the work days via table (vLookup) , iDays
post days,
post arrive date... =DateAdd("d",iDays, [departDate])

 

[Aj80]

This a part of a workbook which has loading dates for different shipments pertaining to different countries....i can do a vlookup for the country and loading daye but to determine the departure date is the problem