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

Free Excel Course –
Paid Online Training –
Best Excel Books:

⚙️ Gear I Recommend:
Camera –
Screen Recorder –
USB Mic –
Wireless Mic:
Lighting –

Subscribe to get awesome Excel Tips every week:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

Rate this post