Networkdays with holidays

[arsenal1983]

Hello,

I have data as below:

REK_id	DATE A	DATE B
10101111	2015-12-30	2016-01-08

in separate table i have a list of holidays.

How can I calculate work days between this two dates and include the holiday list?

[Anonymous]

define a variable for your Holidays and selet the data from your Holiday list

LET vHolidays= concat(yourholidayfield,',')

and use function

networkdays(DATE A, DATE B, '$(vHolidays)')

[sasikanth]

HI,

try like

NetworkingDays(DATE A,DATE B,HOLIDAYS)

[marcus_sommer]

Another way to calculate working-days could be to create a flag within your master-calendar and simply to summarize this flag-field, like: sum(WorkingdaysFlag), see here an example:

Master Calendar with movable holidays

- Marcus

[tamilarasu]

A clear example from manual,

If you have multiple dates, then assign the dates in variable and follow the syntax suggested by Rudolf.

[settu_periasamy · Accepted solution]

And Look at this

Find Net Working Days