Question

What function should be inserted in cell B6 on the Shipping Calculator worksheet to calculate the Estimated Date of Arrival using only the required number of business days?

a) =WORKDAY(TODAY(), B6)
b) =EDATE(TODAY(), B6)
c) =NETWORKDAYS(TODAY(), TODAY()+B6)
d) =DATE(TODAY().YEAR, TODAY().MONTH, TODAY().DAY+B6)

Answer 1

The correct function to calculate the Estimated Date of Arrival using business days in cell B6 of a Shipping Calculator worksheet is =WORKDAY(TODAY(), B6), which adds the specified number of working days to the current date, excluding weekends.

Step-by-step explanation:

To calculate the Estimated Date of Arrival in a shipping calculator worksheet by accounting only for business days, you should choose the option that uses the WORKDAY function. The correct formula to be inserted in cell B6 is:

=WORKDAY(TODAY(), B6)

This function takes a start date and a number of working days to add. The starting date in this case is TODAY(), which represents the current date, and it adds the number of workdays specified in cell B6, excluding weekends and any specified holidays, which is exactly what's needed for an Estimated Date of Arrival calculation in a business context. Neither the EDATE function nor the NETWORKDAYS function would give the desired result, as they do not properly account for working days in the same way.