title: GETPIVOTDATA in Googlesheets doesn't seem to be working when picking a date column (#REF error)
body: <p>I am trying to get GETPIVOTDATA to work right while using dates.  I have looked at multiple questions here on SO that are for GETPIVOTDATA, but none of them use a date in a reference.  </p>
  
  <p>I can create a pivot table with the following data and pull out the total for a given division and subdivision.  But I can't crack the code to handling dates right in GoogleSheets version of GETPIVOTDATA, even though my code works in MS Excel.</p>
  
  <p>this data comes from the googledocs supportpage: <a href="https://support.google.com/docs/answer/6167538?hl=en" rel="nofollow noreferrer">https://support.google.com/docs/answer/6167538?hl=en</a></p>
  
  <p>division    subdivision product number  number of units Date    price per unit<br> 
  east    1   1   14  3/1/2018    $10<br> 
  east    2   1   15  3/1/2018    $11<br> 
  west    1   1   11  3/3/2018    $10<br> 
  west    2   1   21  3/4/2018    $9<br> 
  east    3   1   16  3/1/2018    $8<br> 
  west    3   1   18  3/6/2018    $12<br> 
  <strong>east  4   1   11  3/7/2018    $9<br></strong> 
  east    1   2   10  3/1/2018    $9 <br> 
  east    2   2   9   3/9/2018    $13<br> 
  west    1   2   12  3/10/2018   $10<br> 
  west    2   2   15  3/1/2018    $10<br> 
  east    3   2   12  3/12/2018   $9<br> 
  west    3   2   16  3/1/2018    $12<br>
  east    4   2   12  3/14/2018   $9 <br></p>
  
  <p>The pivot table is anchored into H1 and the columns listed are 
  division,   subdivision,    Date,   SUM of number of units
  in cells H1, I1, J1, K1 respectively</p>
  
  <pre><code>23  =GETPIVOTDATA(K1,H1,"division", "east", "subdivision", 4) 
  #REF!   =GETPIVOTDATA(K1,H1,"division", "east", "subdivision", 4, "Date", datevalue("2018-3-07")) 
  #REF!   =GETPIVOTDATA(K1,H1,"division", "east", "subdivision", 4, "Date", DATE(2018, 3, 7)) 
  </code></pre>
  
  <p>It should return "11" which is the intersection of east, 4 and 3/7</p>
  
  <p>The #REF errors return with "Field combination not found in pivot table for function GETPIVOTDATA" even though it seems like all of the fields are listed. As you can see, I can get my summary value if I use two division and subdivision, but not when I add the Date field.  I have tried multiple ways to match the datevalue in the pivottable.</p>
  
  <p>I am flustered.  What silly thing am I missing here?  Please check that your answer actually works in GoogleSheets before suggesting it :)
  Thanks!</p>