Calculate working days between two date/time field excluding weekends

[abishaymathewd]

I have two date columns i.e

Proposal date    Login date
30/11/2020       4/12/2020
27/11/2020       1/12/2020

I want to create a third column, which is the difference in number of business/working days between the two dates i.e. if there is a weekend(Saturday & Sunday) between the 2 dates, it should not be counted.

Proposal date    Login date    Difference
30/11/2020       4/12/2020     4
27/11/2020       1/12/2020     2

[andrejz]

Hi,

Please look at

Calculating the number of working days between 2 dates in KNIME

I am new to KNIME and I am having to calculate the number of working days between two dates - I have looked at other discussions but for some reason, they are not working for me. Maybe I am missing something/ doing something wrong? For context: My data source has dates ranging from Jan 2019- May 2020.

Calculating the number of working days between 2 dates in KNIME

Hi, I have made some research and found the math formula for calculate the working days between two dates ( https://alecpojidaev.wordpress.com/2009/10/29/work-days-calculation-with-c/ ) and here is the workflow NumberWorkDays.knwf (16.5 KB)