Date & Time =WORKDAY(start_date, days, [holidays])

Quiz =WORKDAY — 15 Questions

15 quiz questions about =WORKDAY — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← WORKDAY ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “days” in =WORKDAY?

Question 2 of 15 2/15

Which function is related to =WORKDAY?

Question 3 of 15 3/15

Does =WORKDAY return a dynamic array?

Question 4 of 15 4/15

Is argument “start_date” required in =WORKDAY?

Question 5 of 15 5/15

In =WORKDAY, which is argument #1?

Question 6 of 15 6/15

Which statement about =WORKDAY is correct?

Question 7 of 15 7/15

Which is the correct syntax of =WORKDAY?

Question 8 of 15 8/15

What is the output type of =WORKDAY?

Question 9 of 15 9/15

How many required arguments does =WORKDAY have?

Question 10 of 15 10/15

What is the type of argument “start_date” in =WORKDAY?

Question 11 of 15 11/15

What usually causes #NUM! in =WORKDAY?

Question 12 of 15 12/15

Since which Excel version is =WORKDAY available?

Question 13 of 15 13/15

In =WORKDAY, which is argument #3?

Question 14 of 15 14/15

Which use case fits =WORKDAY?

Question 15 of 15 15/15

Which formula is a valid example of =WORKDAY?

Click a question to see the answer.

1. What is the type of argument “days” in =WORKDAY?

A. Array
B. Range
C. Number ✓
D. Mixed

Explanation: Type of “days” is “Number”.

2. Which function is related to =WORKDAY?

A. ISODD
B. ODDFYIELD
C. XNPV
D. TODAY ✓

Explanation: “TODAY” is related to WORKDAY.

3. Does =WORKDAY return a dynamic array?

A. Yes
B. No ✓
C. —
D. No

Explanation: WORKDAY does not spill.

4. Is argument “start_date” required in =WORKDAY?

A. Yes
B. Yes ✓
C. —
D. No

Explanation: “start_date” is required.

5. In =WORKDAY, which is argument #1?

A. start_date ✓
B. holidays
C. range
D. lookup_value

Explanation: Argument #1 is “start_date”.

6. Which statement about =WORKDAY is correct?

A. Volatile and recalculates every time
B. Requires add-in
C. Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
D. To calculate the serial number of the date before or after a specified number of workdays by using parameters to indicate which and how many days are weekend days, use the WORKDAY.INTL function. ✓

Explanation: Correct: To calculate the serial number of the date before or after a specified number of workdays by using parameters to indicate which and how many days are weekend days, use the WORKDAY.INTL function.

7. Which is the correct syntax of =WORKDAY?

A. =WORKDAY(start_date, days, [holidays], 0)
B. =WORKDAY(start_date, days, [holidays]) ✓
C. WORKDAY(start_date, days, [holidays])
D. =TODAY(start_date, days, [holidays])

Explanation: Correct syntax: =WORKDAY(start_date, days, [holidays])

8. What is the output type of =WORKDAY?

A. Text
B. Date ✓
C. Value
D. Mixed

Explanation: Output is “Date”.

9. How many required arguments does =WORKDAY have?

A. 4
B. 2 ✓
C. 1
D. 3

Explanation: =WORKDAY has 2 required, 1 optional (3 total).

10. What is the type of argument “start_date” in =WORKDAY?

A. Mixed
B. Array
C. Range
D. Date ✓

Explanation: Type of “start_date” is “Date”.

11. What usually causes #NUM! in =WORKDAY?

A. Requires add-in
B. If start_date plus days yields an invalid date, WORKDAY returns the #NUM! error value. ✓
C. Only works in old versions
D. Volatile and recalculates every time

Explanation: If start_date plus days yields an invalid date, WORKDAY returns the #NUM! error value. — Fix: مقدار days را کاهش دهید یا تاریخ شروع متفاوتی انتخاب کنید تا تاریخ حاصل معتبر باشد.

12. Since which Excel version is =WORKDAY available?

A. Excel 365
B. All versions ✓
C. Excel 2019
D. Excel 2007 (Compatibility)

Explanation: Version: “All versions”.

13. In =WORKDAY, which is argument #3?

A. criteria
B. holidays ✓
C. days
D. lookup_value

Explanation: Argument #3 is “holidays”.

14. Which use case fits =WORKDAY?

A. Date & Time Calculations ✓
B. Data Cleaning
C. Depreciation
D. Conditional Aggregation

Explanation: Use case “Date & Time Calculations” fits WORKDAY.

15. Which formula is a valid example of =WORKDAY?

A. =WORKDAY(A2,A3, 0)
B. =TODAY(A2,A3)
C. WORKDAY(A2,A3)
D. =WORKDAY(A2,A3) ✓

Explanation: Correct example: =WORKDAY(A2,A3)