• Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
Have any question?
(00) 201277767728
[email protected]
RegisterLogin

Login with your site account

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now

Planning Engineer Est.
  • Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
      • Cart

        0

    Excel in Planning

    • Home
    • Blog
    • Excel in Planning
    • Video How to calculate working days using excel with sample

    Video How to calculate working days using excel with sample

    • Posted by Hany Ismail, MSC, PMP
    • Categories Excel in Planning
    • Date November 18, 2012
    • Comments 1 comment

    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:calculate working days, Count Work Days, excel, excel in planning, formulas in excel, Microsoft MS Excel, working days

    • Share:
    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.

    Previous post

    Project Management Plan from Planning Engineer Point of View
    November 18, 2012

    Next post

    Create Gantt Chart and cash flow using excel with sample file
    November 23, 2012

    You may also like

    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
    3 weeks look ahead schedule
    3 weeks look ahead schedule excel sheet
    24 July, 2021

    Leave A Reply Cancel reply

    You must be logged in to post a comment.

    Cart

    0

    Planning Courses

    Cost Control for Construction Projects

    Cost Control for Construction Projects

    $299.00
    Power Bi Monitoring and Controlling with P6

    Power Bi Monitoring and Controlling with P6

    $299.00
    Advanced Planning 3 Courses Package

    Advanced Planning 3 Courses Package

    $499.00
    Data Management and Reporting

    Data Management and Reporting

    $199.00
    Primavera Online Basic Course -Arabic

    Primavera Online Basic Course -Arabic

    $99.00
    Professional Planning Engineer (PPE)

    Professional Planning Engineer (PPE)

    $335.00
    Claims Management and (EOT)

    Claims Management and (EOT)

    $175.00
    Primavera Online Basic Course -English

    Primavera Online Basic Course -English

    $99.00

    Follow Us:

    About Us | Contact Us | Terms of Service | Privacy Policy | Refund Policy

    Copyright ©2012- 2018 planningengineer.net | All materials, unless otherwise noted, were developed originally for Planning Engineer Website. In the event that there is still a problem or error with copyrighted material, the break of the copyright is unintentional and noncommercial and the material will be removed immediately upon presented proof.

    • Planning Courses
    • Planning Jobs
    • Planning Blog
    Posting....