Microsoft Excel 2021365 - Beginner to Advanced - Using the WORKDAY and WORKDAY.INT Functions

The video tutorial explains two Excel functions: the workday function and the workdays int function. The workday function calculates the finish date of tasks by excluding weekends and optionally holidays. The workdays int function extends this by considering international weekends and holidays. Examples demonstrate how to use these functions effectively in project planning.

What does the workday function primarily exclude when calculating finish dates?

• Weekends

• Public holidays

• Weekdays

• Leap years

Which argument is optional in the workday function?

• Start date

• Days

• Holidays

• End date

What additional feature does the workdays.intl function offer compared to the workday function?

• It excludes all holidays by default

• It automatically updates dates

• It includes international weekends

• It calculates in hours instead of days

In the workdays.intl function, how can you specify a weekend that starts on Sunday?

• By excluding Sunday from the calculation

• By selecting Sunday and Monday as weekend days

• By using a different formula

• By setting the start date to Sunday

What is a common use case for the workdays.intl function?

• Calculating the number of hours in a workday

• Adjusting for different international weekend days

• Automatically generating project plans

• Excluding all public holidays