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

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! :slight_smile:

Jeff

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

4 Likes