Pivot Table Question

[lkona]

I am looking at historical Real Estate info. I have data in the following format:

MLS#(ID) Listed Date End Date
12345 1/1/2010 1/1/2011
etc...


I have about 25000 rows of the data (can be broken up if needed). I need to find a way to count the number of active listings in any given month. I am hoping to be able to do it in the context of a pivot table to make the date easy to work with. Any thoughts on how this can be accomplished? Any help would be greatly appreciated. The data will reach back to 1990. I am using Excel 2013.

 

[ghrain22]

This would be better done in the data source. In the data source create another column with the month() function refrencing the column with the date you would like to organize by. Remember to give the column header a name.

After you refresh this new column should be visible in you feild list. Add it as a Row label.

 

[lkona]

Perhaps I don't fully understand the Month() function, but I can't quite get it to fit the application. The trouble I am having with the solution is that I need each month and associated year that listing was active, not just the start and end date. Any thoughts on how I can accomplish that? I am really struggling.