Calculate Working Days Between Two Dates in Excel (excluding Weekend & Holidays)

In today's video, I will show you how to calculate working days between two dates in Excel.

The following five examples are covered in this video:
-- Calculating the total number of days between two dates
-- Calculating working days (excluding weekend days and holidays)
-- Calculating working days (when weekend days are not Saturday and Sunday)
-- Calculating working days in a part-time job
-- Calculating the number of Mondays in between two dates.

For calculating working days, Excel has two functions - NETWORKDAYS and NETWORKDAYS.INTL.

These formulas allow you to specify the weekend days as well as the holidays.

This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[KrisMcCracken]

Fantastic advice. Wonderfully explained and it works a treat!

[marandawatanabe]

You’re the best at explaining this!!!! Thank you!

[rubykarim]

Very clear explanations, clear video and graphs. Thank you!

[alexanderpruger]

Thanks for the subtitles! Something different.

[gunshowdeepburn]

Thanks you so much. This is really helpful.

[Quijanos]

Well done my friend! This was helpful.

[lievenquidousse]

Great Formula. Helped a lot! Thanks Sumit !

[roxannejohnson]

This one is very useful. Good to know!

[andraspeter]

Thank you! It is very usefull! There i found one of the best shortcut:F4 or Fn+F4...absolutely extraordinar! Thank you! Have a nice day!

[puneetvij]

Sumit Sir,
The video was very informative and your trend 'excel in 2 minutes' is a very good one, time savvy! ; )

[ericazg]

Excellent video! So straightforward. How would you enter weekends if I have every other Friday off? I've added them as holidays which works well but wondering if there is an easier/better way?

[Ahmed-fqsi]

I wonder why this guy still hasn't more than 1 million subscribers.

[GurdeepSingh-hjqd]

Hi sir Thanx for all videos, Plz let us now how to calculate leave days from joining date to annual leave starting date. (as per less then 5 years into 21 days and more then 5 years to 10 years 28 days.

[sasikumar]

Exclude only 2nd and 4th Saturday in Start date to end date

[muzaffarsiddiqui]

Thanks, excellent information.
I want one more tip, for example, if I am defining country name with each date and want to dynamically look at the holiday's list where information is populated as country and holiday date, the country will be repeated with each holiday. There will be more than 3 countries on the holiday list. Can you make a video on that or let me know what formula will be? Thanks in advance for your help.