Armazenar uma série de datas em uma célula de planilhas do Google

Isso armazenará a matriz de datas em PropertiesService e as recuperará de PropertiesService e mostrará que elas fazem uma data adequada com Utilities.formatDate (). Basta executar o código e uma caixa de diálogo é razoavelmente autoexplicativa.

function arrayOfDays()
{
    var dayA=[1,2,3,4,5,6,7,8,9,10];
    var today=new Date().setHours(0,0,0,0);
    var day=24*60*60*1000;
    var days=[];
    for(var i=0;i<dayA.length;i++)
    {
      days.push(Utilities.formatDate(new Date(today + (i * day)), Session.getScriptTimeZone(), "MM/dd/yyyy"));

    }
    //Logger.log(days);
    var ui=HtmlService.createHtmlOutput('<h1>Array of Stored Dates</h2><br /><strong>This is the days array:<br/></strong> [' + days.join(', ') + ']');
    storeDates(days);
    var d=getDates();
    var s='<br /><strong>This is the array after it has been stored in PropertiesService and recovered from PropertiesService.</strong>';
    for(var i=0;i<d.length;i++)
    {
      s+='<br />' + Utilities.formatString('Date[%s]=%s <strong>Makes a new Date with Utilities.formatDate(new Date(d[i]), Session.getScriptTimeZone(), "MM/dd/yyyy HH:mm:ss")</strong> -> %s', i,d[i],Utilities.formatDate(new Date(d[i]), Session.getScriptTimeZone(), "MM/dd/yyyy HH:mm:ss"));
    }
    ui.append(s).setWidth(1200);
    SpreadsheetApp.getUi().showModelessDialog(ui, 'Array of Stored Dates')
}

function storeDates(dA)
{
  PropertiesService.getScriptProperties().setProperty('DateArray', dA.join(','));
}

function getDates()
{
  return PropertiesService.getScriptProperties().getProperty('DateArray').split(',');
}