I am trying to accomplish the following:
A1: Beginning Date.... e.g. 1/1/14
A2: Ending Date..... e.g. 1/31/14
Column A (rows 3:50) - Date (sent out date)
Column C (rows 3:50) - Date (received date)
Column D (rows 3:50) - Date (processed date)
I can get the first part of the sumproduct formula down:
=sumproduct((Sheet1!A3:A50>=A1)*(Sheet1!A3:A50<=A2)*...............rest that I don't know)
Every row will have a date (sent out date) in Column A and Column C and Column D will have data (date) as items are received (Column C) and then moved to processed (Column D). I am trying to find out the average number of days it takes for an item to be sent out (Column A) to processed (Column D) if Column D has a date.
Thank you for any help.
Josh
Bookmarks