Pivot table dates issue

[salse]

Hi,


I've got a set of data with start and end dates. I'm looking to create a pivot table and ultimately a chart that shows month by month how many plans started and how many ended.

Take a look at the attached worksheet, its correct showing that 5 plans started in August and one in september, yet it's showing that 4 ended in august and none in september when it should be 3 ending in august and 1 in september.

Thanks for your help!