Excel Magic Trick 1265

DESCRIPTION

NETWORKDAYS.INTL Function: Calculate Net Workdays (8 examples)
Learn how to use NETWORKDAYS.INTL function to calculate net working days when you are given a start and end date, what days in the week are weekends and what days between the start and end date are holidays:
(00:12) Example 1: Default Behavior: Calculate net working days when weekends are Saturday and Sunday and there are no holidays. Example uses an end date that is bigger than the start date.
(01:27) Example 2: Default Behavior: Calculate net working days when weekends are Saturday and Sunday and there are no holidays. Example uses a start date that is bigger than the end date.
(02:02) Example 3: Calculate net working days when weekends are Sunday and Monday and there ARE holidays. This example shows how to use the dropdown option list in the 3rd argument for weekends.
(02:35) Example 4: Learn how to hard code holiday dates into formula using array syntax and text dates.
(04:06) Example 5: Learn how to hard code holiday dates into formula using array syntax and serial numbers that represent actual dates.
(04:35) Example 6: Learn how to hard code holiday dates into formula using array syntax and serial numbers that represent actual dates if you already have the proper dates in the cells and you do not want to have to type them into your formula. We will use the F9 key to evaluate the range in the formula and then hard code the serial numbers in array syntax into the formula.
(05:53) Example 7: What to do if weekends for your situation is not a built-in option in the 3rd argument dropdown, weekend argument? Create text string that is seven digits long, where 1 = weekend and 0 = workday.
(07:06) Example 8: hard code holidays and weekends into the formula.
(07:28) Summary

WORKBOOKS




Be the first to comment

Leave a Reply