Pivot Chart that shows average number between dates.

Hello, I am trying to make a piviot chart that can show the average duration between dates. What I mean is, I have a list if dates attached and I want to have a chart made that shows the average distance between the days. Any help would be great!Dates to sort.xlsx

So you want a single number? For example I have three dates: Feb 1, Feb 2 and Feb 5. The gap from Feb 1 to Feb 2 is one day, The gap between Feb 2 to Feb 5 is three days. So the average is (1 + 3) / 2 or 2 days.

yes exactly. The purpose of making it a pivot chart is because I want to be able to seperate it. I showed only dates in my attachment, but there are 3 other columns that are in here and one of the columns is names. So basiclly I want to be able to say that this guy has an average of XX days between dates and so on.

You might not need a pivot table to do that; an array formula can do the job. See this article: http://www.utteraccess.com/wiki/inde...inIf_AverageIf. Let me know if you need help with the formula.