Excel Calculating Delivery Dates in Excel - Strategic Finance

This formula starts out simply enough, specifying the ship date from cell B2 and the days in transit from cell D2. To derive the Weekend value, a VLOOKUP function uses the shipper code in cell C2 to find the cor-rect code from the table in Figure 2. The fourth argu-ment points to the range of holiday dates from Figure 1. Formatting the Answer ... ................
................