holidays | Feriados Nacional | Runtime Evironment library

I am building an appointment scheduling page using the table-calendar widget. I can write appointments to a firebase collection/document. Now, I need to pull the appointments from the collection and display them as a list below the calendar.

I have used this code on another page and I actually copied if from there and am using it here. The code works on the other page but I am getting the error here. There are small differences in the 2 pages but not too many. What is causing this error?

Here is the code for the calendar page.

I am trying to create an array, where each "Working Day" is an object with an index and start/end date but I have no clue how to manipulate the JSON to have a specific structure.

I am using the following package: https://github.com/SheetJS/sheetjs

Current code:

How to filter the following array with another array values?

I am getting an array of holidays from DB . and I want to check whether selected date is present in the holiday list array. in PHP

var_dump($result2); // holiday list

I’m using ELK – 7.12.1 and in Kibana dashboard i need to filter below holidays date using painless.

What I'm trying to achieve:

• Create a formula that calculates a deadline date using four variables : StartDate, Over2%Date, Percentage, Currency
• If Percentage < 2%, the function should first calculate (StartDate + 120)
• If Percentage >= 2%, the function should first calculate the lesser of (StartDate + 120) and (Over2%Date + 30)
• The resulting date cannot fall on a weekend or a holiday, so the function should subtract days until a valid working day is found.
• The range containing the list of holidays to check will vary depending on Currency

Example:

I'm working with the following dataset:

and a list holidays = ['2016-01-01','2016-01-18'....'2017-11-23','2017-12-25']

Objective: Create a column indicating whether a particular date is within +- 7 days of any holiday present in the list.

Mock output:

I'm working with a lot of date records and thus trying to find a quick(most optimized) way to do this.

My Current Solution:

One way I figured to do this quickly would be to create another list with only the unique dates for my desired duration(say 2 years). This way, I can implement a simple solution with 2 for loops to check if a date is within +-7days of a holiday, and it wouldn't be computationally heavy as both lists would be relatively small(730 unique dates and ~20 dates in the holiday list). Once I have my desired list of dates, all I have to do is run a single check on my 'Date' column to see if that date is a part of this new list I created. However, any suggestions to do this even quicker?

I have a vacation excel where the worker vacations are calculated. My country has postponed holidays where we have to work on weekends. I was wondering if it is possible to add a list as I did with holidays in the NETWORKDAYS formula. How can I make an excel formula that if sees a date in a list that is between 2 dates to add it automatically (count as a workday) so I don't have to do it manually? Have a nice day!

Suppose I have an original lxml tree as following:

my_data.xml