Calculate working day

New Contributor

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

4 Replies
Here is a quick tool to do so... https://www.timeanddate.com/date/weekdayadd.html

Hope this helps!

Best,
Bp

@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.

@Marguerite_Delbet 

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 

S1565.png

Many thanks Hans, that is what I was after, as I have a statutory definition of working days in the legislation I work with and I need to be able to exclude some specific days. I will try and make it work and If I may, come back to you if I can't. I really appreciate your help.