Video How to calculate working days using excel with sample

Definition of Working Days:

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

 

 

calculate working days

Usually we need to calculated Working Days Between 2 Dates, However to Count Work Days Excel you need to identify the week ends and the holidays. Microsoft excel can do this for us in 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, week end and holidays and

calculate working days
calculate working days

excel will calculate how many days between the start date and end date and deduct the week ends and holidays. very simple 🙂

 

Check the following video to see how you can do it in excel

See the video:

 

 

 

Down oad The Sample File

Working Days

 

Tag:, , , , , ,

Hany Ismail, MSC, PMP
Hany Ismail, MSC, PMP

Hany Ismael is the founder and CEO of Planning Engineer Est. in Egypt. He has started his career back in 2003 as a site engineer, technical office engineer, planning engineer, planning manager, and finally planning department manager where he has been involved in several mega construction projects in Egypt and Saudi Arabia. In 2016, he established his own company in Egypt “Planning Engineer Est.” Hany gained his MSc degree in project management from Liverpool University-UK 2013-2016, PMP certified from PMI-USA 2010, and BSc Civil Engineer Tanta University-Egypt 2003. Hany provided more than 3,500 hours of planning and project management training on his website planningengineer.net, YouTube channel, and offline courses since 2011. He enjoys teaching project management in simple and practical way, and he developed several planning tools, techniques and courses.

You may also like

Copy of Precast Buildings Planning (2)
Create Cost Loading Using Power Query
7 September, 2022
Materials Procurement Scheduling in a Baseline Programme
Materials Procurement Scheduling in a Baseline Programme
7 May, 2022
Planned VS Actual Excel Sheet
Mini Schedule Planned VS Actual Excel Sheet
18 August, 2021

Leave A Reply