title: Excel Pivot Table Grouped Dates
body: <p>I inserted a pivot table with a named table as the data source, and am using the date value as a Column Label. The dates are either 1/0/1990(blanks), late December 2015, or early January 2016. </p>
  
  <p>I would like to only display dates from 2016, so I used the "Date Filter" to only show values from this year (I tried doing this both by entering the dates manually, and just selecting "This Year"). </p>
  
  <p><a href="http://i.stack.imgur.com/VeTO7.png" rel="nofollow">http://i.stack.imgur.com/VeTO7.png</a></p>
  
  <p>However when I do this I can now select to see dates "&lt;1/1/2015",any of the months, or ">12/31/2015". Obviously if I want to see items from 2016, this is not much use, as they are all grouped under one "grouping checkbox" (">12/31/2015"). </p>
  
  <p><a href="http://i.stack.imgur.com/rmm9y.png" rel="nofollow">http://i.stack.imgur.com/rmm9y.png</a></p>
  
  <p>So right now, with all of my 2016 dates falling under January, the only column label visible is ">12/31/2015", instead of showing "Jan".</p>
  
  <p><a href="http://i.stack.imgur.com/L5eza.png" rel="nofollow">http://i.stack.imgur.com/L5eza.png</a></p>
  
  <p>How can I get the pivot table to display the month names for my data, instead of ">12/31/2015"?</p>
  
  <p><a href="http://i.stack.imgur.com/M8IF4.png" rel="nofollow">http://i.stack.imgur.com/M8IF4.png</a></p>