LastWorkDate do not exclude holidays from variable

[MT4T]

Hello,

I have an issue with LastWorkDate / NetWorkDays.

Need to calc turnaround time (TAT) for service center.

I have a list of holidays from excel (maintained by externals) which I convert to variable, but below script does not exclude holidays from variable.

lastworkdate("Data rozpoczęcia naprawy", 5 ,'$(vDniWolne)') as DZIEN_TAT_N,
lastworkdate("Data rozpoczęcia naprawy", 3 ,'$(vDniWolne)') as DZIEN_TAT_P,

On sheet I see correctly Master Callendar with joined Holidays (Święto).

In variable vDniWolne is correctly loaded all days from my excel including my example '26/12/2022' - which is monday

But as you can see on bellow screen it show this day in table as workday, it should be excluded.

I think there is something in way I use variable value '$(vDniWolne)' and script or chart function lastworkdate read it wrong.

[pedrobergo · Accepted solution]

Hi @MT4T 

Since all members from variabe vDniWolne contain single quotes, you just need to use $ expansion signal, like:

lastworkdate(Data, 3 ,$(vDniWolne))

[],

Pedro