Calculating days between dates but exclude weekends and national holidays

Hello everyone,

The problem I'm facing is building an API for an internal application in my company. The application involves adding a vacation, among other things. When setting the vacation date, we should specify the number of days between the start date of the vacation and the end date of the vacation.

I found a tutorial on how to prepare such a thread, but there is a problem, all days are taken into account in the calculations. I need to eliminate days off such as weekends or national holidays.

I tried to use AI, but the solutions it offers me are too abstract for me and often do not rely on Xano's capabilities.

Is there anyone who can lend a helping hand on this topic?

1 reply