Hello everyone,
I am in need of some help. I want to import the average days it takes to submit an order until it gets delivered. I have the data in one workbook and i need to transfer the results to another separate workbook.
For each week starting from 1/1/2018 I want to find the average working(network) days between when an order gets receive 01/09/2018(start date) to when the order is delivered 2/25/2018 (end date), I want to exclude holidays and weekends, and the orders are filtered by what type of order it is. There are 4 types of orders and I only need 2 types (Machine, Tech) of order to get the average days.
So far, I can only get the average if i transfer the data over to the other workbook and do a lot of multiple formulas to get the average. I just want one formula that can pull the number without having to have the data repeated in the same workbook.
Column A Column B Column C
Type of Orders Date the order received Date the order is delivered
I am in need of some help. I want to import the average days it takes to submit an order until it gets delivered. I have the data in one workbook and i need to transfer the results to another separate workbook.
For each week starting from 1/1/2018 I want to find the average working(network) days between when an order gets receive 01/09/2018(start date) to when the order is delivered 2/25/2018 (end date), I want to exclude holidays and weekends, and the orders are filtered by what type of order it is. There are 4 types of orders and I only need 2 types (Machine, Tech) of order to get the average days.
So far, I can only get the average if i transfer the data over to the other workbook and do a lot of multiple formulas to get the average. I just want one formula that can pull the number without having to have the data repeated in the same workbook.
Column A Column B Column C
Type of Orders Date the order received Date the order is delivered