Holiday | Check whether a date is a holiday | Calendar 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

My problem is the following:
I usually backup files (e.g. pictures) on external harddisc drives and the store them away in safe places. In the meantime also on NAS. But I don't want to have them connected and online all the time, for power and security reasons.
If I'm now looking for an old file (e.g. a special jpg from the holiday in April 2004) I would have to connect a few discs and search them for the needed file. To overcome this problem I usually create a recursive dir-dump into a textfile for the whole disc after backup.
This way I can search the filename in the text-file. But there still is a problem if I don't exactly know the file name that I am looking for. I know the Year and month and maybe the camera I was using then, but there must be hundreds of files in this month.

Therefore I would like to create a "dummy"-backup-filesystem with all the filesnames on the harddisc but without the actual data behind it. This way I could click through the folders and see the foldernames and filenames and easily find the respective file.

The question is: How do I create such a filesystem copy with the complete folderstructures but only the filenames and not the data?
I'm working on Linux, Opensuse, but I guess this is not a linux specific question.

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!