How to Calculate the Number of Working Days between two dates in Excel | NETWORKDAYS function

In this video I'll show you how to use a simple formula in Microsoft Excel to calculate working or business days between dates.

This is a great Excel formula for anyone planning deadlines and needs to find the number of working days available to them. This function excludes weekends as well. If you use NETWORKDAYS.INTL you can decide which days are considered weekends and should be excluded.

What's Inside:
A detailed guide on using Excel's Network Days function.
Tips for calculating the number of working days between dates, excluding weekends and holidays.

Key Highlights:
Network Days Function: Learn how to use the function to calculate working days between start and end dates.
Handling Holidays and Weekends: Differentiate between 'Network Days' and 'Network Days International' for custom weekend settings.
Practical Example: Application in a project timetable scenario.
Dynamic Selection for Different Countries: Adapting the function for international projects with varying holidays.
Advanced Techniques: Combining Network Days with INDEX and MATCH functions for dynamic holiday lists.

If you need to calculate the number of working days based on given start and end dates, you need to use the NETWORKDAYS function.

I also show you a way to make the selection for holidays dynamic. For example, if you are doing a project in one country and want to roll out that same project in other countries and you’d like the number of working days between the two dates to consider the holidays of the chosen country – the index function can come to the rescue.

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[DirkOutdoor]

At this point here, Leila, I want to thank you for all the videos I've seen from you until now. And thank you for the very clear English you speak and the perfect explanations so I can follow you without using a dictionary. I'm looking forward to watch all your other videos and be sure: I will watch them ALL! You make my Excel Life more and more interesting. Greetings from Koblenz, Germany and thumb north! 👍👍👍

[olgafre]

This is the best channel I ever seen for excel help

[soumiamoujane]

I Love your videos Leila. They are useful and helpful. Thank you very much.

[bornwithoutboundariestarot]

Leila, can you assign criteria to "NETWORKDAYS"... as in, only counting the days while a project is in a certain phase.
I have my columns assigned as "Asset Type", "Process", and Start and End date. I want to track and average of how many NETWORKDAYS each "Asset Type" stays in each "Process" phase (there are 10 possible inputs for this). The reason is it will be beneficial to my team to track the average of how long each asset type is taking us to produce, and how long we stay on each stage. This analysis will help us create best practices to improve process efficiencies.

[pratikpadariya]

It's really very useful for me.. 😊😊

[MrWhisper]

So wrapped to have come across this video. You’re a life saver!!!

[HoppiHopp]

Excellent video. Great preparation and execution.

[TaraJohnston-ku]

Hello. This video has helped me so much. Thank you. I am still receiving an error. I am calculating how long it is taking my employees to complete a task so I am not including the start date. I added 1 to the start date as you said. It is working for almost all of my dates except when they complete the task the same day. Start Date = End Date is not working. I am getting a negative 2 (-2) for my answer. Any suggestions?

[aasirelmutasim]

Hi Lelia, I would like to thank you about all informative and helpful tutorial. Can you teach us how we can automatically create shift schedule?!

[KelvinKeahey]

Awesome video. Great style and information. I’m setting the tablet up on my desk so I can easily reference you in a pinch.

[missmarshmallowzz]

Thanks Leila. How to adjust this formula to count Saturday start date or/and end date? For example, if start date is on Friday, end date is on Saturday, how to get the working day as 1 instead of 0?

[mohammadmazhar]

Thanks for the nice video. What do it do if I have to get time instead of days... Example: I want to when something has crossed 100 working hours starting from Thursday 7 PM ...if I use workdays it doesn't calculate exact time but go by day taking Thursday as full day although it was not full day instead it was just a few of the the day... Your help will be much appreciated

[excelcomputer]

your method of teaching is good and reasonable and I got a lot of new style of excel. I want to get knowledge about macro from beginning because my concept about macro is not clear

[chrissaz]

Thanks! But I think using Indirect function with named range probably would be a bit easier.

[ia]

Hi Leila.. Thank you for a wonderful youtube series..
Need a quick help --> Can we use the formula as mentioned here:
=NETWORKDAYS(1-Apr-2022, 30-Apr-2022)
Please help confirm

[Gchrgr]

What if I want to exclude from the count only the holidays?
I mean that all days are working days for my calculation, except for official holidays.
Is there another formula that does this? Any other workaround for it?

Not to forget: THANKS for the GREAT series of

[amandeepsinghpannu]

What to do when Statutory holiday falls on the weekend? In Canada we get Monday off as a holiday in addition to Saturday Sunday, when stat holiday falls on the weekend (so 3 days off instead of 2 days). NETWORKDAY HOLIDAY function ignores the holidays on the weekend.

[MAJIDMANSOOR]

Hmmm Good one Miss i will Practice of this formula thank you

[nancikalidin]

Hi Leila.i have a long list of end dates with format mm/dd/yyyy and I have to calculate the age difference between today's date (current date change daily, 15/01/2023, 16/02/2023 etc).can I use this formula to calculate excluding sat &sun..despite the date format are not same?

[royeden]

Thanks for the tutorial!! I have one issue, when I add +1 and the start date and end date are the same it is returning 2 instead of 0 ...any idea how can I fix it?? I do not want the start date to be calculated as 1 hence I have added a +1 to the start date