Forum Discussion
joshua1990
1 year agoPost Prodigy
Working Days between to Dates and different countries
Hi experts!
I have a table that contains 2 date columns, 1 colunn with the article and 1 column with the country.
Now I would like to determine the working days between the dates.
The challenge is now that for each country different working days / public holidays exist.
- How would you build the calendar table (structure) to make sure we can easily extract the public holidays / working days in the end?
- Which function / approach would you use to determine the working days?
Thanks in advance!
2 Replies
- lbendlinSuper User
- PwerQueryKeesSuper User
And you may have a look at Global Holiday Calendar API for National and Religious Holidays - Calendarific
They have a free plan as well....