auto-increment the number of working days in a workflow


I hope this message finds you well.

I’m currently facing a challenge in my KNIME workflow and I would appreciate your expertise in solving it. In my dataset, I need to create a column containing a constant value that starts at 1, corresponding to the number of working days at the beginning of the month, and increments each day after the workflow is refreshed until the end of the month (the number of days corresponds to the number of working days in the month). Then, this value should reset to 1 at the beginning of each month.

Do you have any suggestions or ideas on how to efficiently implement this in KNIME?

Thank you in advance for your valuable assistance.

Best regards,

Hello @Romaric_Tekem,

Do you mean that the count automatically increases when the date changes, excluding Saturdays and Sundays? Right?