Appreciate you folks possibly helping on this formula.
I am looking for a single cell formula, it will calculate the average number of days between orders during a 30 day period. (The value of the order doesn't matter) For simplicity imagine that three orders come in during the 30 days, on Days 3, 21, 22.
Date range is 1 through 30
The first interval average is 21-3=18
and the second interval is 22-21=1
The average interval overall is (18+1)/2 = 9.5 days
It seems easy, the hard part for me is the 'end of the first interval is the beginning of the second interval'. Maybe there is some advanced array formula that already does this?
I am looking for a single cell formula, it will calculate the average number of days between orders during a 30 day period. (The value of the order doesn't matter) For simplicity imagine that three orders come in during the 30 days, on Days 3, 21, 22.
Date range is 1 through 30
The first interval average is 21-3=18
and the second interval is 22-21=1
The average interval overall is (18+1)/2 = 9.5 days
It seems easy, the hard part for me is the 'end of the first interval is the beginning of the second interval'. Maybe there is some advanced array formula that already does this?