Use Table Column in a formula

[asalamun]

I have my list of holidays as a column in an excel file, how do I call this table column as my holiday list inside of the Networkdays() formula?

[marcus_sommer]

You could use a $-sign expansion for it, like:

networkdays(Date1, Date2, '$(=concat(Holidays, chr(39) & ',' & chr(39)))')

- Marcus

[sunny_talwar]

May be look here:

Exclude holidays using Networkdays() in script

[asalamun]

I'm trying to use it within my load statement to get a NetWorkDays field

Here is what my holidays data looks like.

[marcus_sommer]

Take a look on the link provided from Sunny which applied the concat-logic within the script.

- Marcus