Microsoft Excel 2021365 - Beginner to Advanced - Using the NETWORKDAYS and NETWORKDAYS.INT Function

This video tutorial explains how to use the Network Days and Network Days International functions in Excel to calculate the number of workdays between two dates, excluding weekends and holidays. It covers the necessary arguments for these functions, demonstrates how to lock cell references, and addresses common issues like incorrect date formatting. The tutorial also highlights the flexibility of the Network Days International function for different global settings.

What is the primary purpose of the Network Days and Network Days International functions?

• To calculate the number of weekends between two dates.

• To calculate the total number of days between two dates, including weekends and holidays.

• To determine the number of workdays between two dates, excluding weekends and specified holidays.

• To find the difference in hours between two dates.

Which argument is NOT required when using the Network Days function?

• Start date

• End date

• Optional holidays

• Time zone

What common mistake can lead to incorrect results when using the Network Days function?

• Not locking cell references

• Using the wrong formula

• Forgetting to include the start date

• Entering dates in the wrong format

How does the Network Days International function differ from the Network Days function?

• It includes weekends in the calculation.

• It allows for different weekend days based on location.

• It automatically adjusts for time zones.

• It calculates the total number of days, not just workdays.

What should you do if your Network Days International function results in dates from 1900?

• Add more holidays to the list.

• Re-enter the start and end dates.

• Ensure the formula is correct.

• Check for incorrect date formatting.