ExcelBanter - Average of Days Between Customers Visits

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Average of Days Between Customers Visits (https://www.excelbanter.com/excel-discussion-misc-queries/447128-average-days-between-customers-visits.html)

Bruce2000

Average of Days Between Customers Visits

Does anyone know the formula for the following situation:

Customer comes in on the following dates and spends accordingly:

Date: 8-31 : 8-30: 8-29: 8-28: 8-27: 8-26: 8-25: 8-24: 8-23: 8-22: 8-21
Spends: $2 $0 $0 $0 $5 $0 $0 $3 $0 $0 $0

Formula for Average # of days between Visits?

All times are GMT +1. The time now is 02:23 AM.