title: Convert Date Value When Using Google Form Date Picker from 5 Digit Format to MM/dd/yyyy format
body: <p>I selected tomorrow's date (8/21/2014) from the data picker field of a Google Form submission, and the value "41872" is returned in the spreadsheet.</p>
  
  <p>What format is this date format?</p>
  
  <p>I need to convert this date format to the MM/dd/yyyy format using script, as formatting the Date column using the Format menu only updates the rows that are currently available...not the new rows that will be there when new form submissions come in.</p>
  
  <p>How do I make this conversion?</p>