
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Networkdays with holidays
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?
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)')
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
try like
NetworkingDays(DATE A,DATE B,HOLIDAYS)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
A clear example from manual,
If you have multiple dates, then assign the dates in variable and follow the syntax suggested by Rudolf.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
And Look at this
