Hi all

I'm struggling a bit to get Excel to calculate an expected time of delivery when I need to count only on workdays (Monday-Friday).

I basically have these columns:

Column 1: Shipment date (given)
Column 2: Shipping days (given)
Column 3: Expected time of delivery (calculated)

So if I e.g. have a shipment date Friday 16.11.2007 with 3 days delivery time I need to have a 21.11.2007 output.

And is it possible to have Excel take public holidays into acount as well?

Thanks,
Kjaer