Difference in dates but not networking days

[Nitin Panjwani]

Hi All,

I have a data which is on country level. I need to find difference between 2 dates but not networking days.

Need your help with finding difference in days which has country-wise holiday list. This holiday list should not be included in the difference.

Thanks in advance for your help.

 

[Chihiro]

Do you mean...

=D2-C2-COUNTIFS($K$2:$K$4,">="&C2,$K$2:$K$4,"<="&D2,$J$2:$J$4,B2)

 

[Nitin Panjwani]

Thanks a lot Buddy