Google Apps脚本中两个日期之间的工作天数 [英] Number of working days between two dates in Google Apps Script

问题描述

任何人都可以在Google Apps脚本中帮助您生成两个日期之间的工作日数. 谢谢.

Could anyone please help with generating number of working days between two dates in Google Apps Script. Thank you.

推荐答案

从用户KBA( https://stackoverflow.com/users /453331/kba )，来自响应

From user KBA (https://stackoverflow.com/users/453331/kba) from response How do I calculate number of given weekday between range using Moment JS?:

var firstDate = new Date("March 1, 2015");
var secondDate = new Date("March 25, 2015");

function getWeekdaysBetweenDates(firstDate, secondDate, dayOfWeek) {
    var MILISECONDS_IN_DAY = 86400000;

    function getNextDayOfWeek(date, dayOfWeek) {
        date.setDate(date.getDate() + (7 + dayOfWeek - date.getDay()) % 7);
        return date;
    }

    firstDate = getNextDayOfWeek(firstDate, dayOfWeek);
    if (firstDate > secondDate) {
        return 0;
    }

    return 1 + Math.floor(((secondDate - firstDate) / MILISECONDS_IN_DAY) / 7);
}

这篇关于Google Apps脚本中两个日期之间的工作天数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！