Hi Guys,
I wanted to find out the average re-order dates for a particular customer. Please see example data below.
Customer 1
01/06/2012 175.53
07/06/2012 17.05
10/01/2012 31.88
10/09/2011 19.29
10/10/2011 66.51
12/08/2011 188.45
12/09/2011 19.38
17/03/2012 76.04
24/03/2013 261.48
27/10/2012 140.95
The dates show the date when the customer placed an order and I want to analyse those dates with a formula to show that for example customer 1 orders every 2 months.
Any help is appreciated.
thanks!
Bookmarks