Calculate Work Days with Custom Days off in Excel

Calculate Work Days with Custom Days off in Excel

Video • 4 minutes

Learning Objectives

  1. Explore the NetworkDays.Intl function in Excel to calculate project durations – including customised work days and excluding holidays.

    Lesson Description

    Imagine a scenario where your work week is not the conventional Monday to Friday and you want to estimate project durations based on this unique schedule, excluding holidays. The tool of choice for this task is the NetworkDays.Intl function. The formula calculates the work days accurately and remains dynamic as you extend it across your dataset. Enhance your Excel skills with this lesson and ensure your project timelines align with your unique work schedule.