title: Issues grouping in excel?
body: <p>I'm having a little bit of trouble grouping dates in excel. I have created a pivot table that groups a bunch of dates between 3 months together. However, I want to take advantage of the refresh ability of pivot tables--the idea in which when you refresh your pivot table, it will update to whatever you added or took away from the source of data your pivot table is based on. </p>
  
  <p>However, when I grouped the dates between three months together, I noticed if I don't add a date that exactly corresponds to the dates within the grouping, the picot table does not add that entry into the pivot table. For example, if my grouping had the following dates (between May and July) in it:</p>
  
  <pre><code>5/21/2013, 7/18/2013, 6/8/2013
  </code></pre>
  
  <p>And in my source data spreadsheet had the following date added to it:</p>
  
  <pre><code>5/2/2013
  </code></pre>
  
  <p><code>5/2/2013</code> would not be added to that specific grouping in the pivot table because it is not  exactly like the other dates as stated above. I want it so that I can group all dates from <code>5/1/2013</code> to <code>7/31/2013</code> inclusively as opposed to the dates in the original grouping. Would anyone have an idea on how to do so? Thanks!</p>