31:T253e,holidays = [ new Date("2000-01-01"), //New Year's Day new Date("2000-01-17"), //MLK Birthday (Observed) new Date("2000-02-21"), //President's Day new Date("2000-05-29"), //Memorial Day new Date("2000-07-04"), //Independence Day new Date("2000-09-04"), //Labor Day new Date("2000-10-09"), //Columbus Day new Date("2000-11-23"), //Thanksgiving Day new Date("2000-11-24"), //Friday after Thanksgiving new Date("2000-12-25"), //Christmas Day new Date("2001-01-01"), //New Year's Day new Date("2001-01-15"), //MLK Birthday (Observed) new Date("2001-02-19"), //President's Day new Date("2001-05-28"), //Memorial Day new Date("2001-07-04"), //Independence Day new Date("2001-09-03"), //Labor Day new Date("2001-10-08"), //Columbus Day new Date("2001-11-22"), //Thanksgiving Day new Date("2001-11-23"), //Friday after Thanksgiving new Date("2001-12-25"), //Christmas Day new Date("2002-01-01"), //New Year's Day new Date("2002-01-21"), //MLK Birthday (Observed) new Date("2002-02-18"), //President's Day new Date("2002-05-27"), //Memorial Day new Date("2002-07-04"), //Independence Day new Date("2002-09-02"), //Labor Day new Date("2002-10-14"), //Columbus Day new Date("2002-11-28"), //Thanksgiving Day new Date("2002-11-29"), //Friday after Thanksgiving new Date("2002-12-25"), //Christmas Day new Date("2003-01-01"), //New Year's Day new Date("2003-01-20"), //MLK Birthday (Observed) new Date("2003-02-17"), //President's Day new Date("2003-05-26"), //Memorial Day new Date("2003-07-04"), //Independence Day new Date("2003-09-01"), //Labor Day new Date("2003-10-13"), //Columbus Day new Date("2003-11-27"), //Thanksgiving Day new Date("2003-11-28"), //Friday after Thanksgiving new Date("2003-12-25"), //Christmas Day new Date("2004-01-01"), //New Year's Day new Date("2004-01-19"), //MLK Birthday (Observed) new Date("2004-02-16"), //President's Day new Date("2004-05-31"), //Memorial Day new Date("2004-07-05"), //Independence Day new Date("2004-09-06"), //Labor Day new Date("2004-10-11"), //Columbus Day new Date("2004-11-25"), //Thanksgiving Day new Date("2004-11-26"), //Friday after Thanksgiving new Date("2004-12-24"), //Christmas Day new Date("2004-12-31"), //New Year's Day (Observed) new Date("2005-01-17"), //MLK Birthday (Observed) new Date("2005-02-21"), //President's Day new Date("2005-05-30"), //Memorial Day new Date("2005-07-04"), //Independence Day new Date("2005-09-05"), //Labor Day new Date("2005-10-10"), //Columbus Day new Date("2005-11-24"), //Thanksgiving Day new Date("2005-11-25"), //Friday after Thanksgiving new Date("2005-12-26"), //Christmas Day new Date("2006-01-02"), //New Year's Day (Observed) new Date("2006-01-16"), //MLK Birthday (Observed) new Date("2006-02-20"), //President's Day new Date("2006-05-29"), //Memorial Day new Date("2006-07-04"), //Independence Day new Date("2006-09-04"), //Labor Day new Date("2006-10-09"), //Columbus Day new Date("2006-11-23"), //Thanksgiving Day new Date("2006-11-24"), //Friday after Thanksgiving new Date("2006-12-25"), //Christmas Day new Date("2007-01-01"), //New Year's Day new Date("2007-01-15"), //MLK Birthday (Observed) new Date("2007-02-19"), //President's Day new Date("2007-05-28"), //Memorial Day new Date("2007-07-04"), //Independence Day new Date("2007-09-03"), //Labor Day new Date("2007-10-08"), //Columbus Day new Date("2007-11-22"), //Thanksgiving Day new Date("2007-11-23"), //Friday after Thanksgiving new Date("2007-12-25"), //Christmas Day new Date("2008-01-01"), //New Year's Day new Date("2008-01-21"), //MLK Birthday (Observed) new Date("2008-02-18"), //President's Day new Date("2008-05-26"), //Memorial Day new Date("2008-07-04"), //Independence Day new Date("2008-09-01"), //Labor Day new Date("2008-10-13"), //Columbus Day new Date("2008-11-27"), //Thanksgiving Day new Date("2008-11-28"), //Friday after Thanksgiving new Date("2008-12-25"), //Christmas Day new Date("2009-01-01"), //New Year's Day new Date("2009-01-19"), //MLK Birthday (Observed) new Date("2009-02-16"), //President's Day new Date("2009-05-25"), //Memorial Day new Date("2009-07-03"), //Independence Day new Date("2009-09-07"), //Labor Day new Date("2009-10-12"), //Columbus Day new Date("2009-11-26"), //Thanksgiving Day new Date("2009-11-27"), //Friday after Thanksgiving new Date("2009-12-25"), //Christmas Day new Date("2010-01-01"), //New Year's Day new Date("2010-01-18"), //MLK Birthday (Observed) new Date("2010-02-15"), //President's Day new Date("2010-05-31"), //Memorial Day new Date("2010-07-05"), //Independence Day new Date("2010-09-06"), //Labor Day new Date("2010-10-11"), //Columbus Day new Date("2010-11-25"), //Thanksgiving Day new Date("2010-11-26"), //Friday after Thanksgiving new Date("2010-12-24"), //Christmas Day new Date("2010-12-31"), //New Year's Day (Observed) new Date("2011-01-17"), //MLK Birthday (Observed) new Date("2011-02-21"), //President's Day new Date("2011-05-30"), //Memorial Day new Date("2011-07-04"), //Independence Day new Date("2011-09-05"), //Labor Day new Date("2011-10-10"), //Columbus Day new Date("2011-11-24"), //Thanksgiving Day new Date("2011-11-25"), //Friday after Thanksgiving new Date("2011-12-25"), //Christmas Day new Date("2012-01-02"), //New Year's Day (Observed) new Date("2012-01-16"), //MLK Birthday (Observed) new Date("2012-02-20"), //President's Day new Date("2012-05-28"), //Memorial Day new Date("2012-07-04"), //Independence Day new Date("2012-09-03"), //Labor Day new Date("2012-10-08"), //Columbus Day new Date("2012-11-22"), //Thanksgiving Day new Date("2012-11-23"), //Friday after Thanksgiving new Date("2012-12-25"), //Christmas Day new Date("2013-01-01"), //New Year's Day new Date("2013-01-21"), //MLK Birthday (Observed) new Date("2013-02-18"), //President's Day new Date("2013-05-27"), //Memorial Day new Date("2013-07-04"), //Independence Day new Date("2013-09-02"), //Labor Day new Date("2013-10-14"), //Columbus Day new Date("2013-11-28"), //Thanksgiving Day new Date("2013-11-29"), //Friday after Thanksgiving new Date("2013-12-25"), //Christmas Day new Date("2014-01-01"), //New Year's Day new Date("2014-01-20"), //MLK Birthday (Observed) new Date("2014-02-17"), //President's Day new Date("2014-05-26"), //Memorial Day new Date("2014-07-04"), //Independence Day new Date("2014-09-01"), //Labor Day new Date("2014-10-13"), //Columbus Day new Date("2014-11-27"), //Thanksgiving Day new Date("2014-11-28"), //Friday after Thanksgiving new Date("2014-12-25"), //Christmas Day new Date("2015-01-01"), //New Year's Day new Date("2015-01-19"), //MLK Birthday (Observed) new Date("2015-02-16"), //President's Day new Date("2015-05-25"), //Memorial Day new Date("2015-03-07"), //Independence Day new Date("2015-09-07"), //Labor Day new Date("2015-10-12"), //Columbus Day new Date("2015-11-26"), //Thanksgiving Day new Date("2015-11-27"), //Friday after Thanksgiving new Date("2015-12-25"), //Christmas Day new Date("2016-01-01"), //New Year's Day new Date("2016-01-18"), //MLK Birthday (Observed) new Date("2016-02-15"), //President's Day new Date("2016-05-30"), //Memorial Day new Date("2016-07-04"), //Independence Day new Date("2016-09-06"), //Labor Day new Date("2016-10-10"), //Columbus Day new Date("2006-11-24"), //Thanksgiving Day new Date("2016-11-25"), //Friday after Thanksgiving new Date("2016-12-26"), //Christmas Day new Date("2017-01-02"), //New Year's Day new Date("2017-01-16"), //MLK Birthday (Observed) new Date("2017-02-20"), //President's Day new Date("2017-05-29"), //Memorial Day new Date("2017-07-04"), //Independence Day new Date("2017-09-04"), //Labor Day new Date("2017-10-09"), //Columbus Day new Date("2017-11-23"), //Thanksgiving Day new Date("2017-11-24"), //Friday after Thanksgiving new Date("2017-12-25"), //Christmas Day new Date("2018-01-01"), //New Year's Day new Date("2018-01-16"), //MLK Birthday (Observed) new Date("2018-02-19"), //President's Day new Date("2018-05-28"), //Memorial Day new Date("2018-07-04"), //Independence Day new Date("2018-09-03"), //Labor Day new Date("2018-10-08"), //Columbus Day new Date("2018-11-22"), //Thanksgiving Day new Date("2018-11-23"), //Friday after Thanksgiving new Date("2018-12-25"), //Christmas Day new Date("2018-Dec-31"), //New Year's Eve new Date("2019-Jan-01"), //New Year's Day new Date("2019-Jan-02"), //Gifted Day Off new Date("2019-Jan-14"), //Snow Day! new Date("2019-01-21"), //MLK Birthday (Observed) new Date("2019-02-18"), //President's Day new Date("2019-05-27"), //Memorial Day new Date("2019-07-04"), //Independence Day new Date("2019-09-02"), //Labor Day new Date("2019-10-14"), //Columbus Day new Date("2019-11-28"), //Thanksgiving Day new Date("2019-11-29"), //Friday after Thanksgiving new Date("2019-12-25"), //Christmas Day new Date("2020-01-01"), //New Year's Day new Date("2020-01-20"), //MLK Birthday (Observed) new Date("2020-02-17"), //President's Day new Date("2020-05-25"), //Memorial Day new Date("2020-07-04"), //Independence Day new Date("2020-09-07"), //Labor Day new Date("2020-10-12"), //Columbus Day new Date("2020-11-26"), //Thanksgiving Day new Date("2020-11-30"), //Friday after Thanksgiving new Date("2020-12-25"), //Christmas Day new Date("2021-01-01"), //New Year's Day new Date("2021-01-18"), //MLK Birthday (Observed) new Date("2021-02-15"), //President's Day new Date("2021-05-31"), //Memorial Day new Date("2021-07-05"), //Independence Day new Date("2021-09-06"), //Labor Day new Date("2021-10-10"), //Columbus Day new Date("2021-11-25"), //Thanksgiving Day new Date("2021-11-26"), //Friday after Thanksgiving new Date("2021-12-25"), //Christmas Day ]32:T51c,function calcBusinessDays(dDate1, dDate2, holidays) { // input given as Date objects var iWeeks, iDateDiff, iAdjust = 0, i; if (dDate2 < dDate1) return -1; // error code if dates transposed var iWeekday1 = dDate1.getDay(); // day of week var iWeekday2 = dDate2.getDay(); iWeekday1 = (iWeekday1 == 0) ? 7 : iWeekday1; // change Sunday from 0 to 7 iWeekday2 = (iWeekday2 == 0) ? 7 : iWeekday2; if ((iWeekday1 > 5) && (iWeekday2 > 5)) iAdjust = 1; // adjustment if both days on weekend iWeekday1 = (iWeekday1 > 5) ? 5 : iWeekday1; // only count weekdays iWeekday2 = (iWeekday2 > 5) ? 5 : iWeekday2; // calculate differnece in weeks (1000mS * 60sec * 60min * 24hrs * 7 days = 604800000) iWeeks = Math.floor((dDate2.getTime() - dDate1.getTime()) / 604800000) if (iWeekday1 <= iWeekday2) { iDateDiff = (iWeeks * 5) + (iWeekday2 - iWeekday1) } else { iDateDiff = ((iWeeks + 1) * 5) - (iWeekday1 - iWeekday2) } iDateDiff -= iAdjust; // take into account both days on weekend for(i = 0; i < holidays.length; i++) { if(holidays[i] >= dDate1 && holidays[i] <= dDate2 && holidays[i].getDay() != 0 && holidays[i].getDay() != 6) { iDateDiff--; } } return (iDateDiff + 1); // add 1 because dates are inclusive } 33:[] 2f:{"title":"Calculate Working Days, Excluding Weekends & Holidays","cells":[{"id":0,"value":"md`# Calculate Working Days, Excluding Weekends & Holidays`","pinned":false,"hidden":false,"mode":"ojs"},{"id":187,"value":"md`We have a snow day here in Washington DC, which prompted me to ask how one would remove holidays from a date range.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":180,"value":"md`This tool owes to [sujith84](https://stackoverflow.com/users/1370959/sujith84)'s [answer on Stack Overflow](https://stackoverflow.com/a/44517197), which in turn appears to owe to [Garis M Suero](https://stackoverflow.com/users/359226/garis-m-suero)'s [Stack Overflow answer to a similar question](https://stackoverflow.com/a/3464346).`","pinned":false,"hidden":false,"mode":"ojs"},{"id":83,"value":"md`**Start Date**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"viewof start_date = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":84,"value":"md`**End Date**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":24,"value":"viewof end_date = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"md`There are **${calcBusinessDays(new Date(start_date.toLocaleString(undefined, {timeZone: \"utc\"})), new Date(end_date.toLocaleString(undefined, {timeZone: \"utc\"})), holidays)}** working days between
**${start_date.toLocaleString(undefined, {timeZone: \"utc\", month: \"long\", day: \"numeric\", year: \"numeric\"})}**
and
**${end_date.toLocaleString(undefined, {timeZone: \"utc\", month: \"long\", day: \"numeric\", year: \"numeric\"})}**\n
\nof a total of **${totalDaysBetween(start_date,end_date)}** calendar days.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"md`I added in my snowday to an array of holidays, defined below. If you'd like to adjust for additional holidays, just click the three dots next to the cell, add your date following the same formatting anywhere in the list (order is irrelevant) and to new total will be reflected in the text above.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":2,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":91,"value":"function totalDaysBetween(past_date, today) {\n // The number of milliseconds in one day\n var ONEDAY = 1000 * 60 * 60 * 24;\n // Convert both dates to milliseconds\n var end_date_ms = end_date.getTime();\n var start_date_ms = start_date.getTime();\n // Calculate the difference in milliseconds\n var difference_ms = Math.abs(end_date_ms - start_date_ms);\n\n // Convert back to days and return\n return Math.round(difference_ms/ONEDAY) + 1 ; //adding 1 to make date range count inclusive\n }","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"import {date} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}