google apps script - Message Box if Cell Range is Today -

i'm new google app script , new coding google sheets. i'm attempting to:

have pop-up box show if date in range of cells equal today.

here's code have far:

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 {} } 

range example

it appears data variable on reads first cell e8. i'm sure simple solution, i'm missing logic it. appreciated.

you may code :

function onopen(){   var ss = spreadsheetapp.getactivespreadsheet();   var sheet = ss.getactivesheet();   var lastrow = ss.getlastrow();   var lastcol = ss.getlastcolumn();   var today = utilities.formatdate(new date(), "gmt+05:30", "''yyyy-mm-dd");   var flag = 'false';   for(var =8; i<=22; i++){     for(var j =5; j<=7; j++){       var data = sheet.getrange(i, j, i, j).getvalue();       var shdate = utilities.formatdate(new date(data), "gmt+05:30", "''yyyy-mm-dd");       if (shdate == today){         browser.msgbox('send required items reminders today!', browser.buttons.ok);         flag = 'true';}         if(flag == 'true')           break;     }     if(flag == 'true')       break;   } } 

hope you.

thanks.