B
Bruce2000
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
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