如何通过Google表格在日期中添加天数?

问题描述：

我不知道如何使用Google Apps脚本从Google表格中向日期添加天数.

I can't figure out how to add days to a date from Google Sheets with Google Apps Script.

for (var i = 0; i < data.length; ++i) {
    var row = data[i];
    var car = row[1];
    var date = row[2];

if ((car == "Car1") || (car == "Car2")) {
        var newDay = new Date(date + 154);
        Logger.log(newDay);
}

我尝试使用new Date(date.add({days: 154}));，但这引发了关于在对象中找不到add()的错误.

I've tried using new Date(date.add({days: 154})); but that throws an error about not finding add() in the object.

我认为这可能是格式问题，在表格中，格式为7/26/2014.

I thought it may be a formatting issue, in Sheets the format is 7/26/2014.

答

可能有很多方法可以实现，这里有2种方法

There are probably many ways to do that, here are 2 of them

知道JavaScript Date的原始值是毫秒，您可以为该原始值加上n乘以3600000 * 24毫秒，n是天数.
或者您可以获取日期值，将n添加到该值并使用该值重建日期.要获得一天，只需使用getDate().在JS日期此处中查看文档.. li>

Knowing that native value of JavaScript Date are milliseconds, you can add n times 3600000*24 milliseconds to this native value, n being the number of days.
or you can get the day value, add n to this value and rebuild the date with that. To get the day simply use getDate(). See doc on JS date here.

下面是一个简单的演示函数，它同时使用两种方法并在记录器中显示结果:

Below is a simple demo function that uses both methods and shows results in the logger :

function myFunction() {
  var data = SpreadsheetApp.getActive().getActiveSheet().getDataRange().getValues();
  for (var i = 0; i < data.length; ++i) {
    var row = data[i];
    var car = row[1];
    var date = new Date(row[2]); // make the sheet value a date object
    Logger.log('original value = '+date);
    Logger.log('method 1 : '+new Date(date.getTime()+5*3600000*24));
    Logger.log('method 2 : '+new Date(date.setDate(date.getDate()+5)));
  }
}

如何通过Google表格在日期中添加天数?

相关推荐