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 business days with no holidays. In the Weekday column, use a function to determine the day of the week each delivery was made. Use Monday and Sunday 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. In the Contact Customer column, use function that displays Contact if the shipment was late, otherwise is blank. In cell K use a function to pull the Product Category based on the Product ID in cell K In cell K use a function to pull the Salesperson based on the Product ID in cell K Use a different function than used in Task In cell K 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
