How to find median/average days between entries (orders) for 50,000 items

[Garuda7]

	9/1/16	9/2/16	9/3/16	9/4/16	9/5/16	9/6/16	9/7/16	9/8/16	9/9/16	9/10/16	9/11/16	9/12/16	9/13/16	9/14/16
Item 1	1			1			1			1			1
Item 2	1											1
Item 3		1	1	1				1		1			1

<tbody>
</tbody>

Hello, I was trying to figure out the best way to find the median/average days between entries. So, from the chart above, Item 1 would have an average of 3 days between entries. For Item 2, it would be 11 days. For Item 3, it is more sporadic which would represent more like my actual data. The date row would be for an entire year and the Item column would have more than 50,000 entries. Doing a "=Count over the period" would not be accurate since, say for instance, Item 4 was entered exactly every week for an entire year so it would have 52 entries and an average of 7 days. But, Item 5, was more of a seasonal item that was entered in the fall and spring and had 26 entries respectively; showing 52 entries but an average of 7 days (falsely). I've come across =Subtract, =NetworkDays, =DatedIf functions but haven't come up with a solution. Any help would be great. Thanks!

 

[oldbrewer]

for item 5 you would have to "ignore" gaps of say more than 10 days

 

[oldbrewer]

01/01/2015	08/01/2015	15/01/2015	22/01/2015	29/01/2015	01/08/2015	09/08/2015	17/08/2015	25/08/2015	02/09/2015	10/09/2015	18/09/2015	26/09/2015
	7	7	7	7	184	8	8	8	8	8	8	8
						set arbritary ignore value of 15
					10		=COUNTIF(A2:M2,"< 15")-1
					84		=SUMIF(A2:M2,"< 15")
						so average gap = 8.4 days

<colgroup><col span="2"><col span="3"><col span="2"><col span="6"><col></colgroup><tbody>
</tbody>