title: Change format of value returned in =TODAY()
body: <p>I'm using the today function in an Excel spreadsheet to return the current date. I am the using the value of the cell with the date in it, to create a formula using an indirect concatenate formula to combine the different parts of the formula that I would like to create. </p>
  
  <p>My issue that I keep receiving a #REF! due to the =TODAY() function returning the date a 6 digit number i.e. 41819 instead of the date format 29/06/1014.</p>
  
  <p>Is it possible to make the indirect concatenate or =TODAY() to change the format of the date when it is returned?</p>
  
  <p><strong>Edited</strong></p>
  
  <p>Here is the formula that returns using the indirect concatenate.</p>
  
  <p>=Dump(GoogleAnalytics("ga:78770227", "ga:visits"," 41819","41789", "","", "", "", 500, FALSE, FALSE))</p>
  
  <p>Instead it should appear like.</p>
  
  <p>=Dump(GoogleAnalytics("ga:78770227", "ga:visits"," 29/06/2014","30/05/2014", "","", "", "", 500, FALSE, FALSE))</p>