Practice WORKDAY & WORKDAY.INTL Function Online in Excel
Watch: How to use WORKDAY & WORKDAY.INTL Function in Excel?
What is WORKDAY Function?
The WORKDAY function in Excel calculates a date that is a specified number of working days before or after a given date. It is used to calculate dates that exclude weekends and holidays. Click here to Read Full TutorialÂ
What is WORKDAY Function Syntax?
=WORKDAY(start_date, days, [holidays])
Practice 1: WORKDAY Online Practice Excel
- Click on the cell where you want the result (e.g.,
F3). - Type
=WORKDAYand open the parentheses. - Select the start date (e.g., click on cell
B4). - Add a comma, then select the number of days to add (e.g., click on cell
F1). - Add another comma, then select the holidays (e.g., drag to highlight the range
B5:B8). - Close the parentheses and press Enter.
What is WORKDAY Function?
The WORKDAY.INTL function in Excel calculates a date that is a specified number of working days before or after a given date. It can be used to calculate project start dates, delivery dates, and completion dates. Click here to Read Full TutorialÂ
What is WORKDAY.INTL Function Syntax?
=WORKDAY.INTL(start_date, days, [weekend], [holidays])
Practice 2: WORKDAY.INTL Online Practice Excel
Click on any cell below to start practicing WORKDAY.INTL Function. Check Instruction how to use the WORKDAY.INTL Function.
- Click on the cell where you want the result (e.g.,
F3). - Type
=WORKDAYand open the parentheses. - Select the start date (e.g., click on cell
B4). - Add a comma, then select the number of days to add (e.g., click on cell
F1). - Add a Comma, then select the weekends
- Add another comma, then select the holidays (e.g., drag to highlight the range
B5:B8). - Close the parentheses and press Enter.
