title: Message Box if Cell Range is Today
body: <p>I'm new to Google App Script and new to coding for Google Sheets.
  I'm attempting to:</p>
  
  <p>Have a pop-up box show if any date in a range of cells is equal to today.</p>
  
  <p>Here's the code I have so far:</p>
  
  <pre><code>function onOpen() 
  {
  var ss = SpreadsheetApp.getActiveSheet();
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Required Items List');
  var ss = SpreadsheetApp.getActive();
  var range = sheet.getRange('Required Items List!E8:G22');
  var data = range.getValue();
  var today = new Date();
  
      Logger.log(data);
      Logger.log(today);
  
        if (data == today) 
        { 
          Browser.msgBox('Send Required Items Reminders Today!', Browser.Buttons.OK);
        }
  
      else {}
  }
  </code></pre>
  
  <p><a href="http://i.stack.imgur.com/PMuxV.jpg" rel="nofollow">Range Example</a></p>
  
  <p>It appears by data variable on reads the first cell for E8. I'm sure its a simple solution, I'm just missing some logic for it. Any help would be greatly appreciated.</p>