title: Changing the title of a column in a PivotTable
body: <p>I am having trouble changing the title of some columns in a pivot table. I'm trying to make them have dates in them. Each date 6 days further from the last. </p>
  
  <p>Like this<a href="https://i.stack.imgur.com/NvBFn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NvBFn.png" alt="enter image description here"></a></p>
  
  <p>But, I cannot get an equation inside the column title to stay, every time I type in the equation and press enter, it evaluates to either <code>0</code> (If the format of the cell is number or general), or  <code>1/0/1990</code> (If formatted as a date). I checked the value of the cell by <code>=ISTEXT(A1)</code> and it evaluates as true. No matter how I format the cell. So I can never change the title to look like the picture. Any ides?</p>
  
  <p>Here is what I have.
  <code>TRUE</code> is the result from <code>ISTEXT()</code></p>
  
  <p><a href="https://i.stack.imgur.com/dQxA7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dQxA7.png" alt="enter image description here"></a></p>
  
  <p>Even if I manually enter in the formula via the function arguments, it'll show up correct, but when I click ok. It will go back to either <code>0</code> or <code>1/0/1990</code></p>
  
  <p><a href="https://i.stack.imgur.com/XTFSR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XTFSR.png" alt="enter image description here"></a>  </p>
  
  <p>Here's the original page
  <a href="https://drive.google.com/file/d/0B3p8Jm7oNAo4ZUN0Qk1mR1cxYmM/view?usp=sharing" rel="nofollow noreferrer">https://drive.google.com/file/d/0B3p8Jm7oNAo4ZUN0Qk1mR1cxYmM/view?usp=sharing</a></p>