How to calculate working days using Excel (Free Download)

What is the definition of Working Days?

It is the period between two dates after deduction the weekends and the holidays, in other meaning the net effective days to work.

Calculating Working days

Usually, we need to calculate Working Days between 2 dates. However, to count work days in Excel you need to identify the weekends and the holidays. Excel can do this for us in a very simple way using the built-in formulas in Excel. To calculate them in Excel simply use the formula NETWORKDAYS.INTL, then select the start date, end date, weekend, and holidays.

Excel will calculate how many days between the start date and end date and deduct the weekends and holidays.

Ready to take your skills to the next level? 🚀 Check out our Special Online Courses! 🚀
Gain valuable insights, boost your career, and learn from industry experts.

Planning Courses

Download the Excel Template to calculate Working Days

Calculate Working Days Excel Template

1 file(s) 10.03 KB

Download

Let’s see how the Excel sheet works.

First step

Assume that the project start date is 1-Jan-2023 and the finish date is 30-Dec-2023.

Make sure that the type of “Text” is “Date”.

You need to select the cells and then “Right Click“.

Then, choose “Format Cells“.

At “Category”, choose “Date”. Then, at “Type” choose the format “DD-MM-YY”.

Second Step

On all days just subtract the finish date and start date, It will give you all the days without any weekends or holidays.

RECOMMENDED COURSE

Data Management and Reporting

Data Management is the key success of construction projects reporting. This self-study course will teach you using a step by step case…

1,681 students
WhatsApp support group
Certificate

View course

This is the equation.

All days from the start date to the finish date.

Third Step

Add the holidays of the year.

Final Step

The equation is “=NETWORKDAYS.INTL(Start date ,end date, (weekend),Holidays).

Choose the date under the start date and the date under the finish date then at the weekend choose which days are your weekend, you have a variety to choose from, If it is two days or one day only.

Then choose the written holidays.

From 363 actual days starting from the start date till the finish date to 257 working days.

As you subtract the holidays and the two weekend days.

Check out this Video

Download the Resources of this Article

How to calculate working days using excel with sample 501.15 KB 2520 downloads

This File is included in the following course(s)

Basic Planning Course

Keep growing with Planning Engineer

Learn with a clear path

From Primavera P6 basics to claims, cost control and Power BI. Start with our free courses.

Browse courses

Get help on WhatsApp

Every course comes with a private WhatsApp support group where our team answers your questions.

Join a course

Find planning jobs

109 open planning and project control jobs. Post your resume so employers can find you.

See jobs

Get tips by email

Free planning tips, templates and course offers. Unsubscribe any time.

Do you want to know how to download this attachments?

Check this article to know how to download our website contents

In this guide, we’ll show you step by step how to access the articles’ resources, where to find them, and which part is free, which part is premium. We will introduce our freemium approach.

Tell Me How To Download