Networkingdays

[aw15281]

Hello,

I am looking for a solution to build the networkingdays formular of excel into KNIME.

Therefore we use in Excel this formular. =NETTOARBEITSTAGE(R14;T14;Feiertage!$A$1:$A$105)

R14 = created on Date e.g. 05.07.2021
T14 = Shall transport disposition date e.g. 07.09.2021

The public holidays were considered by a seperate List.

As result we get 47 net working days.

I would really appreciate it if you can help me at this point to build it up in KNIME workflow.

Thanks in advance

Sebastian

[andrejz]

Hi,

Look at Calculating the number of working days between 2 dates in KNIME

Hope this helps
Regards
Andrej

[ipazin]

Hello @aw15281,

and welcome to KNIME Community!

Check out this topic as well as it might have example you can use:

Date&Time Shift skip Weekends and count public holidays

Hello guys, I try to calculate a target date. For example see my first row. Start date is 31.01.2019 (Thursday). Adding two working days should lead to a target date 04.02.2019 (Monday), but with the Date& Time Shift Node I only will get the 02.02.2019 which is a Saturday. Anyone else faced this issue already and solved? [KNIME%20date%20and%20time%20shift] In addition I want to check if within start date and target date is a public holiday. My input would be a table which contains this infor…

Also there is existing ticket to have this functionality inside KNIME so added +1 for you. (Internal reference: AP-5966). Upon news someone will update this topic to notify you.

Br,
Ivan