Calculate the number of working days between 2 columns and removing weekends and holidays

[jepavila]

Hi Everyone,

I need help on my workflow. I am trying to figure out how to calculate the number of days between 2 columns excluding weekends and holidays. I couldn’t seem to find any solution in KNIME. It’s gonna be an easy one in excel using the networkdays formula.

Can someone help? Below is the expected result.

Thanks in advance!

Jeff

[HansS]

Hi @jepavila

This is a very popular topic when you search the KNIME Forum . Just to another solution to it. See this wf calculate_number_of_days_exclude_weekends_holidays.knwf (60.0 KB). It uses some dummy data I create. To test the wf you have to provide your own data.

.
gr. Hans