Hi,
I'm stuck with a particular kind of formula in excel. I'm looking to calculate the average amount of days it takes for a transaction to be completed for each month. I have a sheet listing when all the expressions of interest and the date/time that this occurred and another listing when the transaction was completed with the date/time. Some expressions of interests never pan out, therefore don't appear in the completed transactions.
For example, I have the data
Expression of interest:
<tbody>
</tbody>
Completed transaction:
<tbody>
</tbody>
Desired data:
<tbody>
</tbody>
Does anyone have any guidance of how I should approach this?
I'm stuck with a particular kind of formula in excel. I'm looking to calculate the average amount of days it takes for a transaction to be completed for each month. I have a sheet listing when all the expressions of interest and the date/time that this occurred and another listing when the transaction was completed with the date/time. Some expressions of interests never pan out, therefore don't appear in the completed transactions.
For example, I have the data
Expression of interest:
Business1 | 4/4/2019 |
Business2 | 4/16/2019 |
Business3 | 4/25/2019 |
Business4 | 5/1/2019 |
Business5 | 5/3/2019 |
<tbody>
</tbody>
Completed transaction:
Business2 | 4/20/2019 |
Business3 | 4/27/2019 |
Business4 | 5/3/2019 |
<tbody>
</tbody>
Desired data:
April 2019 | =Average days taken to complete transaction in April 2019 |
May 2019 | =Average days taken to complete transaction in May 2019 |
<tbody>
</tbody>
Does anyone have any guidance of how I should approach this?