Hallo,
Column A I insert a date (Departing date)
Column B I insert another date (Arrival date).

I would like with Vba (vba because sometimes I might need to adjust the
B30 date) once I input a date from cell A30 to obtain in B30 another
date plus a value in A20 (transit time) with the following checks:
- date in B30 = date in A30
- date in B30 = today's date
- date in B30 + A20 (skip Sat. and Sundays)

For example:
Column A20 = 3 (transit time)
Column A30 = 17 jan 2013 (departing time)
Column B30 = 22 jan 2013 (arrival time)

Thanks for any help and/or suggestions.
Regards
Paul