Calculate Working Days in Excel Excluding Weekends & Holidays | inc 3 Day Weekend

Download the featured file here: www.bluepecantraining.com/wp-...
In this video I demonstrate how to count the number of working days between two dates excluding weekends and holidays. You can achieve this using either the NETWORKDAYS function or the NETWORKDAYS.INTL function.
I demonstrate the following in the video:
How to exclude weekends (Sat and Sun)
How to exclude Sundays
How to exclude a three day weekend (Sat, Sun and Mon - or any other combination of non-working days)
How to count all the Fridays between two dates (or any other day of the week)
How to count the number of days left until an end date in such a way that the calculation will automatically update based on the current date.
This video will answer the following queries:
How to calculate number of working days between two dates in Excel
How to calculate working days in Excel excluding weekends and holidays
Can Excel calculate working days including Saturday?
What is the Excel formula to calculate working days between a date and today?
------------------------

[@IvanCortinas_ES]

Great trick with "0" and "1". Thank you Chester!!! Super!

[@soumiamoujane3695]

Thanks for your video. It has helped me alot. Excellent video and explanation.

[@tribecupid5746]

Excellent video! Very helpful and concise. Subscribed!! The only bit I’m not sure I understand is why you use 0s and 1s and how you decide which to use for which day. ….As a bonus, I would also have loved to know if there is a way to automate the updating of the bank holiday dates if you expect your data to span years, but this really would have been bonus not essential content (…although if you feel like answering 😉)

[@ubaidillahmuhammad20]

loved it, sir

[@udayanmurali]

Great Sir, !!!!!

[@simfinso858]

Great video , how can I get dates for for all working days after applying this formula.

[@john0139]

Hi. How to calculate the elapsed working days excluding weekends & holidays?

[@sreeshinet]

Thanks

[@claudiasequeira7069]

Hi! How can we make the formula only include the holidays on week days? Since if we don't do it it will remove the same date 2 times, right?

[@soumiamoujane3695]

What's the formula to calculate the number of bank holidays in a given month?.

[@soumiamoujane3695]

Hi when I try this and type the formula and type bank holiday it dose not work

[@daddystabz]

How can you do this not to calculate business days between 2 dates excluding weekends and holidays but to put a date in a cell and in another cell put how many business days out, like 15, and have it to tell you what date that would fall on excluding weekends and holidays?

[@miiihaaas]

Does anyone have an idea how to create and use list of working Saturdays and use that list (with opposite criteria) as holiday list?
VBA is acceptable as solution too :)

[@sreeshinet]

Thanks