Question: In the Business Days column, use a function to determine the date of delivery assuming all shipments must be delivered in 5 business days with

In the Business Days column, use a function to determine the date of delivery assuming all shipments must be delivered in 5 business days with no holidays. 2. In the Weekday column, use a function to determine the day of the week each delivery was made. Use Monday =1 and Sunday =7.3. In the On Time column, use a function to display Early if the shipment was delivered before the expected date, On Time if the shipment was delivered on the expected date, and Late if delivered after the expected delivery date. 4. In the Contact Customer column, use function that displays Contact if the shipment was late, otherwise is blank. 5. In cell K2, use a function to pull the Product Category based on the Product ID in cell K1.6. In cell K3, use a function to pull the Salesperson based on the Product ID in cell K1. Use a different function than used in Task 5.7. In cell K5, use a function to enter todays date. The date should not display time.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!