networkdays, concatenate limited list of holidays

[#1]

Hi,

would you be able to help?

I have a table like this:

DateA,                DateB,              

2016-12-08          2017-01-02

2016-12-10          2016-12-27

..

Calendar in my application is built on DateA. Next to Calendar table I have table with all holidays that is linked by DateA too (with indicator Holiday = 1 next to holiday dates).

I need to calculate in my table number of working days (so networkingday - holidays). I have no problem with counting networkdays. But i need to add to the formula concatenated list of holidays. How to write function to concatenate only dates related to dates between DateA and B, so that i do not put concatenated list of holidays for five years??

Concat(all if(Holiday = 1, DateA), ',') - worked for me to list all the holidays..

Thank you for any help

Tom

[adamdavi3s]

You can use the P function to do this in set

P() & E() and where do you use them?

[adamdavi3s]

This might also help

Exclude Holiday from NetWorkDays