Forum Discussion
Solved
How to calculate days elapsed between transaction
Hello, I work for a non-profit and am trying to get insight into how frequently each of our donors contribute financially. I have a donor register with names, dates, amounts. I currently am summ...
If you're on 365, this might be your solution:
=LET(filtered,FILTER($F$2:$F$21,$D$2:$D$21=I2),dates,COUNT(filtered),IF(dates>1,AVERAGE(DROP(filtered,-1)-DROP(filtered,1)),filtered))
Can you please post few sample data (better to attach a sample excel file) and show your desired output.
Harun24HR thanks for your response.
I want to find the days between each transaction, per PayerID, for repeat donors.
This exercise seeks to find the frequency and ultimately average time between each transaction, per repeat donor.
| PayerID | Amount | Date Received |
| 1458662946 | 51.1 | 11/4/2022 |
| 12167270467 | 200 | 11/4/2022 |
| 12131763519 | 110 | 11/3/2022 |
| 12131757642 | 25000 | 11/3/2022 |
| 7809555286 | 21 | 6/26/2022 |
| 7809555286 | 38 | 6/22/2022 |
| 7804539738 | 102.2 | 10/17/2022 |
| 7736255381 | 61.32 | 6/17/2022 |
| 7396511985 | 100 | 6/14/2022 |
| 7392399070 | 1000 | 6/12/2022 |
| 7392361055 | 40000 | 9/4/2022 |
| 7388445731 | 20.44 | 6/24/2022 |
| 7368787451 | 25 | 9/13/2022 |
| 7368787451 | 25 | 8/13/2022 |
| 7368787451 | 25.55 | 8/13/2022 |
| 7368787451 | 25 | 7/13/2022 |
| 7368787451 | 25.55 | 7/13/2022 |
| 7368787451 | 102.2 | 6/7/2022 |
| 7354195806 | 10 | 6/4/2022 |
| 7354184301 | 100 | 6/4/2022 |