Calculate work days with custom days off in Excel
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 remain...
Corporate Author: | |
---|---|
Format: | eBook |
Language: | English |
Published: |
[Place of publication not identified]
Assemble You
2024
|
Edition: | [First edition] |
Subjects: | |
Online Access: | |
Collection: | O'Reilly - Collection details see MPG.ReNa |
Summary: | 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. Learning Objectives Explore the NetworkDays.Intl function in Excel to calculate project durations - including customised work days and excluding holidays |
---|---|
Physical Description: | 1 video file (4 min.) sound, color |