Getting list of dates (excluding weekends)

set datefirst 1

;with cte as
(select cast('20111101' as datetime) as dt union all select dt+1 from cte where dt<'20111201')

select count(*) as cnt from cte
where dt between '20111123' and '20111129'
  and datepart(dw, dt) < 6

library('dplyr')

holiday <- data.frame(h = as.Date(c("2016/05/3", "2016/05/3"),'%Y/%m/%d'), 
                      s = c('state1','state2'),
                      stringsAsFactors=FALSE
                      )

d <- data.frame(d1 = as.Date(c('2016/05/2','2016/05/2'),'%Y/%m/%d'),
                d2= as.Date(c('2016/05/10','2016/05/10'),'%Y/%m/%d'),
                s = c('state1','state3'),
                stringsAsFactors=FALSE)

state <- as.character(unique(d$s))

#function to exclude weekends and holidays
f <- function(a, b, h) { 
  d <- seq(a, b, 1)[-1]   
  sum(!format(d, "%u") %in% c("6", "7") & !d %in% h)
}
vf <- Vectorize(f, c("a", "b"))

#Function to calculate days excluding weekends and holidays by state
#state is done iteratively
datalist = list()
for (i in 1:length(state)) {
  # ... make some data

  #extract holidays by state as vectors
  holi <- holiday %>% 
    filter(s== state[i]) %>%
    select(h) %>%
    pull()

  #create new data by state
  dat <- d %>%
    filter(s == state[i])
  dat$diff <- with(dat,vf(d1, d2, holi))

  datalist[[i]] <- dat # add it to your list
  rm('dat')
}

new_df = dplyr::bind_rows(datalist)

          d1         d2      s diff
1 2016-05-02 2016-05-10 state1    5
2 2016-05-02 2016-05-10 state3    6

var holidays = new List<DateTime>();

var holidays = null;

function getBusinessDays(start_date, end_date)
{
    var start = new Date(start_date);
    var end = new Date(end_date);
    var current = start;
    var dates = [];

  while(current<=end) // while the "current" date is <= the end date
  {
    if(current.getDay() !== 6 && current.getDay() !== 0) // check if not Sat or Sun
    {
        dates.push(new Date(current)); // add date to array
    }
    current.setDate(current.getDate() + 1); // increase current date by 1 day
  }

  return dates;
}

var businessDays = getBusinessDays('10/01/2019', '11/29/2019');

console.log(businessDays);