title: Max function not working on import range in google spreadsheet
body: <p>I am new to google spreadsheet functions and trying to apply formula in following way:</p>
  
  <p>I have an imported range as under in cell B2:</p>
  
  <pre><code>=importrange("1gRRBtq7KMAr5kY5AJBqFcLarkikqrAqr5CbeTc5mPzE/edit#gid","dstr!b2:b400")
  </code></pre>
  
  <p>This range contains different dates &amp; I am trying to select last date with following function in B1:</p>
  
  <pre><code>=max(B2:B398)
  </code></pre>
  
  <p>But in place of showing date it is showing value.</p>
  
  <p>Please help in solving this concern, for more detail you can go to following page:</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1HTXf4VG2JupiP9UqCLRyAddYjhsom1leQOI9-DwfMaY/edit#gid=0" rel="nofollow">https://docs.google.com/spreadsheets/d/1HTXf4VG2JupiP9UqCLRyAddYjhsom1leQOI9-DwfMaY/edit#gid=0</a></p>