How can I use javascript to return the number of vacation days between two dates, excluding holidays?

Question

I have a code that returns the number of days between two dates selected using jQuery datapicker.

I would like to add a function for the holidays that excludes all holidays in the array; var holidays [25-12-2016,26-12-2016,1-1-2017];

find the code below:

            <script>
            <!--Calculate Leave days excluding weekends
            function calcBusinessDays(start, end) {
                // This makes no effort to account for holidays
                // Counts end day, does not count start day

                // make copies we can normalize without changing passed in objects    
                var start = new Date(start);
                var end = new Date(end);

                // initial total
                var totalBusinessDays = 0;

                // normalize both start and end to beginning of the day
                start.setHours(0,0,0,0);
                end.setHours(0,0,0,0);

                var current = new Date(start);
                current.setDate(current.getDate() + 1);
                var day;
                // loop through each day, checking
                while (current <= end) {
                    day = current.getDay();
                    if (day >= 1 && day <= 5) {
                        ++totalBusinessDays;
                    }
                    current.setDate(current.getDate() + 1);
                }
                return totalBusinessDays;
            }

                $(function() {
                $( "#start_date" ).datepicker({ minDate:0, showOn: 'button', buttonImageOnly: true, buttonImage: 'images/calendar.png', beforeShowDay: $.datepicker.noWeekends });
                    $( "#end_date" ).datepicker({ minDate:0, showOn: 'button', buttonImageOnly: true, buttonImage: 'images/calendar.png',beforeShowDay: $.datepicker.noWeekends,
                    onSelect: function (dateStr) {
                    var max = $(this).datepicker('getDate'); // Get selected date
                    $('#datepicker').datepicker('option', 'maxDate', max || '+1Y+12M'); // Set other max, default to +18 months
                    var start = $("#start_date").datepicker("getDate");
                    var end = $("#end_date").datepicker("getDate");
                    var days = (end - start) / (1000 * 60 * 60 * 24);
                    var diff = calcBusinessDays(start,end);
                    $("#leave_days").val(diff);

                } });

              });



            </script>

  <input name="start_date" type="text"   id="start_date"  />  

 <input name="end_date" type="text"   id="end_date" /> 

 <input  name="leave_days" type="text"  id="leave_days" size="32" class="form-control"/>  

Answer 1

As stated in the comments, you will need to define an array of holidays.

In this example, I defined two dates: 2016-11-23 and 2016-12-02

script, .
, script MySQL, YYYY-MM-DD.
.

current MySQL, . while , , , , , " " .

var holiday_array=["2016-11-23", "2016-12-02"];   // YYYY-MM-DD (Default MySQL date format)

function dateToMySQL (x){
    var MySQL_day = x.getDate();
    if(MySQL_day<10){
        MySQL_day = "0"+MySQL_day;      // Leading zero on day...
    }
    var MySQL_month = x.getMonth()+1;   // Months are zero-based.
    if(MySQL_month<10){
        MySQL_month = "0"+MySQL_month;  // Leading zero on month...
    }
    var MySQL_year = x.getYear()+1900;  // Years are 1900 based.
    var MySQL_date = MySQL_year+"-"+MySQL_month+"-"+MySQL_day;
    return MySQL_date;
}

function calcBusinessDays(start, end) {
    // This makes no effort to account for holidays
    // Counts end day, does not count start day

    // make copies we can normalize without changing passed in objects    
    var start = new Date(start);
    var end = new Date(end);

    // initial total
    var totalBusinessDays = 0;

    // normalize both start and end to beginning of the day
    start.setHours(0,0,0,0);
    end.setHours(0,0,0,0);

    // Prepare loop variables
    var current = new Date(start);
    current.setDate(current.getDate() + 1);
    var day;
    var holidayFound=false;

    // loop through each day, checking
    while (current <= end) {
        //console.log("current: "+current);

        // Check if current is in the holiday array
        var MySQLdate = dateToMySQL(current);
        console.log("MySQL date: "+MySQLdate);

        if($.inArray(MySQLdate,holiday_array)!=-1){
            console.log("                  ^----------- Holiday!!!");
            holidayFound=true;     // "flag"
        }

        // If current is monday to friday and NOT a holiday
        day = current.getDay();
        if (day >= 1 && day <= 5 && !holidayFound) {
            ++totalBusinessDays;
        }

        // For next iteration
        current.setDate(current.getDate() + 1);
        holidayFound=false;
    }
    return totalBusinessDays;
}

$(function() {
    $( "#start_date" ).datepicker({
        minDate:0,
        showOn: 'button',
        buttonImageOnly: true,
        buttonImage: 'http://www.nscale.net/forums/images/misc/Tab-Calendar.png',    //'images/calendar.png',
        beforeShowDay: $.datepicker.noWeekends
    });
    $( "#end_date" ).datepicker({
        minDate:0,
        showOn: 'button',
        buttonImageOnly: true,
        buttonImage: 'http://www.nscale.net/forums/images/misc/Tab-Calendar.png',    //'images/calendar.png',
        beforeShowDay: $.datepicker.noWeekends,
        onSelect: function (dateStr) {
            var max = $(this).datepicker('getDate'); // Get selected date
            $('#datepicker').datepicker('option', 'maxDate', max || '+1Y+12M'); // Set other max, default to +18 months
            var start = $("#start_date").datepicker("getDate");
            var end = $("#end_date").datepicker("getDate");
            var days = (end - start) / (1000 * 60 * 60 * 24);
            var diff = calcBusinessDays(start,end);
            $("#leave_days").val(diff);

        }
    });
});

CodePen ( ;))

Answer 2

:

function workingDaysBetweenDates(startDate, endDate) {
    var millisecondsPerDay = 86400 * 1000; 
    startDate.setHours(0,0,0,1);  
    endDate.setHours(23,59,59,999);  
    var diff = endDate - startDate;     
    var days = Math.ceil(diff / millisecondsPerDay);
    
    // Subtract two weekend days for every week in between
    var weeks = Math.floor(days / 7);
    days = days - (weeks * 2);

    // Handle special cases
    var startDay = startDate.getDay();
    var endDay = endDate.getDay();
    
    // Remove weekend not previously removed.   
    if (startDay - endDay > 1)         
        days = days - 2;      
    
    // Remove start day if span starts on Sunday but ends before Saturday
    if (startDay === 0 && endDay != 6)
        days = days - 1 ; 
            
    // Remove end day if span ends on Saturday but starts after Sunday
    if (endDay === 6 && startDay !== 0)
        days = days - 1  ;
    
    return days;
}

var a = new Date(2015, 10, 16); 
var b = new Date(2016, 01, 20);
var t = workingDaysBetweenDates(a,b);
alert(t);

Hide result

, !