Jul 13 2022 04:37 PM
Hello
I am trying to calculate how many working days there are between two dates. Some of these dates are holidays too. Any idea how I would do this?
Many thanks in advance for your help!
Marguerite
Jul 13 2022 06:49 PM
Jul 13 2022 09:33 PM
@Bipin-prakash Thank you so much, that's perfect and a lot easier than building a model! And I like it that is removes the holidays from the country you are in.
Jul 14 2022 03:11 AM
You already have a solution, but if you want to calculate it in Excel, take a look at the NETWORKDAYS function and/or NETWORKDAYS.INTL function
Jul 14 2022 07:36 PM