I'm trying to automate holiday exclusion in NetWorkDays but keep getting an error.
My app helps control a process. Employees from different countries must complete a task within 48 working hours - excluding weekends and public holidays. Each employee has different public holidays since they're from different countries.
I've been using NetWorkDays(StartDate, EndDate) with the right result. I've also tried adding holidays manually and it works: NetWorkDays(StartDate, EndDate, '01.01.2020', '02.01.2020').
If I try to use a concat for the holidays, it breaks. I've tried all the options below. Needless to say, when I print simply the results of the Concat, everything is fine.