Business Days count

[#1]

This Macro is intended to allow you to count the businessdays between 2 dates for each row in your dataset.

In the macro, you can :

• specify which are your business days
• take into account your company/organisation specific holidays
• take into account your country holidays for (at the moment, I'm open to add more countries if you can share a link with the rules for the country) :
  • Canada
  • France
  • Germany
  • Ireland
  • Switzerland
  • UK (England)
  • UK (scotland)
  • UK (Northern Ireland)
  • USA

The attached package contains the macro itself and a demo workflow for easier use.

I hope it helps.

Do not hesitate to contact me if you find an error or think about an upgrade.

[Hamder83]

hi @Ladarthure 

This is a great macro.

I have a wish :D We are a transport company that ships all over europe. And sometimes we do calculations across countries.

Lets say 
Row 1:
2022-07-27 - 2022-07-28 - ToCountry: Denmark

2022-07-20 - 2022-07-21 - ToCountry: Germany

We have a holyday date table that contains the specific countries.

with option to match input data country to holiday country

[Ladarthure]

Hi @Hamder83, thank your for your feedback, I just added a few countries for holidays :)

I understand your need and it's a great idea, I will see if I can rework the macro to have it working this way!

[DanTh]

Super helpful!

[salunkheashish6]

Hello,
I do not have a list of holiday file and dont want to mention holidays, Can I still make the macro work by inputing two initial date columns ?

[Ladarthure]

Hi @salunkheashish6,

yes it should work without holidays, you just have to input a start date and end date en select the days which are considered to be businessdays. If it does not work tell me so that I can give you an example!

[Wrigh6s]

Great tool - just imported and it worked right away. I wondered if there was a similar tool that did it based on start date and then today's date rather than a specific end date. 

[Ladarthure]

@Wrigh6s you could simply add a formula to create the end date with today's date just before calculating it. It would do the job or duplicate the tool to have it working the way you want :)

[Anvil]

@Ladarthure Thanks for that! what would be the best method to easily add add multiple countries (Switzerland, Canada for example)

[Ladarthure]

Hi @Anvil I try to add as many countries as possible, it is not hard if you have a specific rule, I can update the macro to include those countries but need to have a set of rules for the country, then I can add those, or you can also modify the macro to include those days. If it's based on easter, I would suggest using the france container. I will try to look at this as soon as possible!

[Ladarthure]

I just updated the macro to add several countries to it!

[MarcosC_]

Hi @Ladarthure

Thanks for this Macro. It's amazing and it was plug and play for me.

Just for my knowledge as I don't know exactly how Macros in Alteryx work (new user) and to ensure continuity as I'm going to use this for an ongoing report, until when does the business calendar go?

Is there a defined end date year on this macro or does it go until year 9999 ? :)