Count Weekdays/Workdays

[mlauber71]

You could try to download the current holidays of a country from a site like Countries | Office Holidays.

I built a workflow doing that. It might useful if you want to take variable holidays like easter into account. Some holidays might only be local ones or might not be bank holidays. So you might have to come up with a rule. Or you could just write them into a list

Dividing and splitting rows

I constructed a workflow that illustrates how you could do it. Basically you first do it like in the example above you count down from the original TargetDay the you expand the possible TargetDays by factor 3 (so you will have enough days once you start eliminating some in-between) then you mark all days that are not suitable like holidays and weekends the remaining ones you just join back by an iteration number and voila you have the new TargetDays [19] the yellow marked columns state why …