title: My app keeps showing today's date and not what is in the cell I called for
body: <p>I am getting the output of the first date of the column date where "exp" should be.  Column 3 is all expiration dates but when I call and output it It shows as a long formatted day date and time.  I know very little if anything about coding.  Please help. </p>
  
  <p>This is what the output should look like except the date should be the date from the from not the top date from sheet.</p>
  
  <p>MJC-AP-200 Watchguard model : AP 200is due in 10 days 09/30/17.</p>
  
  <p>DMA-AP-300-2 Watchguard model : AP 300is due in 0 days 09/30/17.</p>
  
  <p>Elwood Properties Watchguard model : WGD-WG026583is due in 0 days 09/30/17.</p>
  
  <p>Elwood Prop-XTM-26W Watchguard model : XTM 26-Wis due in 0 days 09/30/17.</p>
  
  <pre><code>  function checkReminder() {
  // get the spreadsheet object
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  // set the first sheet as active
  SpreadsheetApp.setActiveSheet(spreadsheet.getSheets()[0]);
  // fetch this sheet
  var sheet = spreadsheet.getActiveSheet();
  
  // figure out what the last row is
  var lastRow = sheet.getLastRow();
  
  // the rows are indexed starting at 1, and the first row
  // is the headers, so start with row 2
  var startRow = 2;
  
  // grab column 8 (the 'days left' column) 
  var range = sheet.getRange(2,8,lastRow-startRow+1,1 );
  var numRows = range.getNumRows();
  var days_left_values = range.getValues();
  
  // Now, grab the name column
  range = sheet.getRange(2, 1, lastRow-startRow+1, 1);
  var reminder_info_values = range.getValues();
  
  // Now, grab the exp date column
  range = sheet.getRange(2, 3, lastRow-startRow+1, 1);
  var exp = range.getValue();
  var numRows = range.getNumRows();
  var exp = Utilities.formatDate(exp, "GMT+1", "MM/dd/yy")
  
  // Now, grab the model column
  range = sheet.getRange(2, 4, lastRow-startRow+1, 1);
  var model = range.getValues();
  
  var warning_count = 0;
  var msg = "";
  
  // Loop over the days left values
  for (var i = 0; i &lt;= numRows - 1; i++) {
  var days_left = days_left_values[i][0];
  if(days_left &lt;= 60) {
    // if it's less than 60 days until due date.
    var reminder_name = reminder_info_values[i][0];
  
    msg = msg + ""+reminder_name+" Watchguard model : " +model[i][0]+"is due 
    in "+days_left+" days "+Utilities.formatDate(exp[i]
    [0],"GMT+1","MM/dd/yy")+".\n \n";
    warning_count++;
    }
    }
  
    if(warning_count) {
     MailApp.sendEmail("James@mccnet.com", 
      "Watchguard Expiration List", msg);
     }
  
  
     };
  </code></pre>