How to Calculate Working Days in Excel - Exclude Any Days, Weekends, Part time job

How to Calculate Working Days in Excel - Exclude Any Days, Weekends, Part-time job

In this video, I'll show you how to calculate days between a start and an end date in Microsoft Excel, excluding days that should not count, like weekends or other holidays. Furthermore, you will find powerful ways to calculate working days for a part-time job. The WORKINGDAYS () function provides flexibility for different scenarios: For example, you can only count certain working days in a week, like Monday, Tuesday, and Friday.

Download DataFX free add-in:

Chapters:

00:00 Intro
00:08 Calculate Working Days excluding Weekends, including Holidays
00:28 Calculate Working Days, excluding Weekends and Holidays
00:56 Calculate Working Days - Part Time excluding Weekends and Holidays
01:23 Calculate Working Days, including Weekends, excluding Holidays
01:52 Calculate Working Days - Part Time including Weekends, excluding Holidays

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

🎁 SHARE this video and spread the Excel love.

Or if you are in a hurry, please click the 👍

#excel #exceltips #exceltutorial #exceltricks

[garimanaithani]

If there is not a workingday function. What will be the work around?