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

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

Question 2 of 15 2/15

What is the fix for #VALUE! in =NETWORKDAYS?

Question 3 of 15 3/15

Which function is related to =NETWORKDAYS?

Question 4 of 15 4/15

Is argument “end_date” required in =NETWORKDAYS?

Question 5 of 15 5/15

What is the output type of =NETWORKDAYS?

Question 6 of 15 6/15

Is =NETWORKDAYS volatile?

Question 7 of 15 7/15

Which is the correct syntax of =NETWORKDAYS?

Question 8 of 15 8/15

Since which Excel version is =NETWORKDAYS available?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Which function is NOT related to =NETWORKDAYS?

Question 11 of 15 11/15

How many arguments does =NETWORKDAYS have in total?

Question 12 of 15 12/15

Which statement about =NETWORKDAYS is correct?

Question 13 of 15 13/15

Is argument “holidays” required in =NETWORKDAYS?

Question 14 of 15 14/15

Which use case fits =NETWORKDAYS?

Question 15 of 15 15/15

Which formula is a valid example of =NETWORKDAYS?

Click a question to see the answer.

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

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

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

2. What is the fix for #VALUE! in =NETWORKDAYS?

A. Output is always a dynamic array
B. Text is always ignored
C. Check the dates and the holiday range ✓
D. Select entire column for best performance

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

3. Which function is related to =NETWORKDAYS?

A. IPMT
B. CONFIDENCE.NORM
C. TODAY ✓
D. BIN2DEC

Explanation: “TODAY” is related to NETWORKDAYS.

4. Is argument “end_date” required in =NETWORKDAYS?

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

Explanation: “end_date” is required.

5. What is the output type of =NETWORKDAYS?

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

Explanation: Output is “Number”.

6. Is =NETWORKDAYS volatile?

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

Explanation: NETWORKDAYS is not volatile.

7. Which is the correct syntax of =NETWORKDAYS?

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

Explanation: Correct syntax: =NETWORKDAYS(start_date, end_date, [holidays])

8. Since which Excel version is =NETWORKDAYS available?

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

Explanation: Version: “All versions”.

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

A. Date
B. Range ✓
C. Value
D. Reference

Explanation: Type of “holidays” is “Range”.

10. Which function is NOT related to =NETWORKDAYS?

A. TODAY
B. WORKDAY
C. DAYS
D. STDEV ✓

Explanation: “STDEV” is not related to NETWORKDAYS.

11. How many arguments does =NETWORKDAYS have in total?

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

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

12. Which statement about =NETWORKDAYS is correct?

A. Volatile and recalculates every time
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. Output is always a dynamic array
D. 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, 2012 is serial number 40909 because it is 40,909 days after January 1, 1900.

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.

13. Is argument “holidays” required in =NETWORKDAYS?

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

Explanation: “holidays” is optional.

14. Which use case fits =NETWORKDAYS?

A. Descriptive Statistics
B. Comparation
C. Daily Tasks ✓
D. Forecasting & Trends

Explanation: Use case “Daily Tasks” fits NETWORKDAYS.

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

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

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