working days count, ignoring holidays and weekends

Hello everyone, I have a question about counting working days, I have to count the working days between columns A and B . However, there is a column for holidays, I would like to count the working days between column A and B, considering the fact that I cannot count the weekends or the days of holidays for each country indicated, and add the result in the column C

image

hi @Moreiraxx,
this is my tentative workflow, hope it will help


working_days.knwf (27.1 KB)

1 Like

Hi @Moreiraxx , is the time in the date important?

For example, if we look at the second row:
2021-12-08 17:22 to 2021-12-10 09:57, that’s not 2 full days, only 1 full day, and if we actually have to remove 2021-12-09 as a holiday, then you do not even get 1 full day, so if you count the number of days for this record, it’s 0 (it’s actually almost 16hrs if I calculated correctly off of my head, which is less than a full day). Is this the result you expected for this line?

Also, in the future, while it’s good to show the data as an image, you should also provide the sample data, either as a text that we can copy and paste, or via a file that we can use in our solution workflow :slight_smile:

Hi @Moreiraxx,

just asking, but the column name is Holidays could there be multiple holidays in a time span?

Best regards,

Paul