Calendar.txt

function scheduleShifts() {

var spreadsheet = SpreadsheetApp.getActiveSheet();
var eventCal = CalendarApp.getCalendarById("murka.com_l0p53jmoi45sec6c6htauui56k@group.calendar.google.com");
  
var signups = spreadsheet.getRange(4, 5, 9, 3).getValues()

var signupsFiltered = [];

var j = 0;

for (var i = 0; i < signups.length; i++) {
   
  Logger.log(signups[i][0] + typeof signups[i][1]);
  Logger.log(signups[i][1] + typeof signups[i][1]);
  
  if(typeof signups[i][1] === "object"){
      signupsFiltered[j] = signups[i];
      j++;
  } else if(typeof signups[i][2] === "object"){
      signupsFiltered[j] = signups[i];
      j++;
  } 
 }
  
Logger.log(signups[0])
  
Logger.log(signupsFiltered);
Logger.log(signupsFiltered.length);
Logger.log(signups.length);

  for (x = 0; x < signupsFiltered.length; x++) {
  
    var shift = signupsFiltered[x];
    
    var manager = shift[0];
    var vacDate = (typeof shift[1] === "string") ? shift[2] : shift[1];
    
    Logger.log('Creating event for user: '+ manager +' on date: ' + vacDate);
    
    eventCal.createAllDayEvent(manager + ' ' + 'has a day off!', vacDate)
  }   
  
}