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.
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.