Date & Time =NETWORKDAYS(start_date, end_date, [holidays])

Quiz =NETWORKDAYS — 15 Questions

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

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

← NETWORKDAYS ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which statement about =NETWORKDAYS is correct?

Question 2 of 15 2/15

Which function is related to =NETWORKDAYS?

Question 3 of 15 3/15

What usually causes #VALUE! in =NETWORKDAYS?

Question 4 of 15 4/15

How many required arguments does =NETWORKDAYS have?

Question 5 of 15 5/15

Which use case fits =NETWORKDAYS?

Question 6 of 15 6/15

Is argument “start_date” required in =NETWORKDAYS?

Question 7 of 15 7/15

Is =NETWORKDAYS volatile?

Question 8 of 15 8/15

What is the output type of =NETWORKDAYS?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

In =NETWORKDAYS, which is argument #1?

Question 11 of 15 11/15

How many optional arguments does =NETWORKDAYS have?

Question 12 of 15 12/15

Which category does =NETWORKDAYS belong to?

Question 13 of 15 13/15

Which function is NOT related to =NETWORKDAYS?

Question 14 of 15 14/15

In =NETWORKDAYS, which is argument #2?

Question 15 of 15 15/15

Which formula is a valid example of =NETWORKDAYS?

Click a question to see the answer.

1. Which statement about =NETWORKDAYS is correct?

A. Select entire column for best performance
B. To calculate whole workdays between two dates by using parameters to indicate which and how many days are weekend days, use the NETWORKDAYS.INTL function. ✓
C. Volatile and recalculates every time
D. Output is always a dynamic array

Explanation: Correct: To calculate whole workdays between two dates by using parameters to indicate which and how many days are weekend days, use the NETWORKDAYS.INTL function.

2. Which function is related to =NETWORKDAYS?

A. CUBEVALUE
B. TODAY ✓
C. FREQUENCY
D. LET

Explanation: “TODAY” is related to NETWORKDAYS.

3. What usually causes #VALUE! in =NETWORKDAYS?

A. Text is always ignored
B. If any argument is not a valid date, NETWORKDAYS returns the #VALUE! error value. ✓
C. Volatile and recalculates every time
D. Only works in old versions

Explanation: If any argument is not a valid date, NETWORKDAYS returns the #VALUE! error value. — Fix: Check the dates and the holiday range

4. How many required arguments does =NETWORKDAYS have?

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

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

5. Which use case fits =NETWORKDAYS?

A. Conditional Logic
B. Daily Tasks ✓
C. Investment Appraisal
D. Descriptive Statistics

Explanation: Use case “Daily Tasks” fits NETWORKDAYS.

6. Is argument “start_date” required in =NETWORKDAYS?

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

Explanation: “start_date” is required.

7. Is =NETWORKDAYS volatile?

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

Explanation: NETWORKDAYS is not volatile.

8. What is the output type of =NETWORKDAYS?

A. Number ✓
B. Date
C. Reference
D. Array

Explanation: Output is “Number”.

9. What is the type of argument “start_date” in =NETWORKDAYS?

A. Date ✓
B. Logical
C. Number
D. Reference

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

10. In =NETWORKDAYS, which is argument #1?

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

Explanation: Argument #1 is “start_date”.

11. How many optional arguments does =NETWORKDAYS have?

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

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

12. Which category does =NETWORKDAYS belong to?

A. Statistical
B. Date & Time ✓
C. Cube
D. Database

Explanation: Category is “Date & Time”.

13. Which function is NOT related to =NETWORKDAYS?

A. REGISTER.ID ✓
B. TODAY
C. WORKDAY
D. DAYS

Explanation: “REGISTER.ID” is not related to NETWORKDAYS.

14. In =NETWORKDAYS, which is argument #2?

A. end_date ✓
B. value
C. holidays
D. lookup_value

Explanation: Argument #2 is “end_date”.

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

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

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