Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
1 year ago
Solved

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.

  1. How would you build the calendar table (structure) to make sure we can easily extract the public holidays / working days in the end?
  2. Which function / approach would you use to determine the working days?

Thanks in advance!