This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 :
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.
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: GermanyWe have a holyday date table that contains the specific countries.
with option to match input data country to holiday country
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!
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 ?
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!
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.
@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 :)
@Ladarthure Thanks for that! what would be the best method to easily add add multiple countries (Switzerland, Canada for example)
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!
I just updated the macro to add several countries to it!