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

Quiz =NETWORKDAYS — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Since which Excel version is =NETWORKDAYS available?

Question 2 of 10 2/10

Which is the correct syntax of =NETWORKDAYS?

Question 3 of 10 3/10

Which statement about =NETWORKDAYS is correct?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

In =NETWORKDAYS, which is argument #3?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

In =NETWORKDAYS, which is argument #1?

Question 8 of 10 8/10

Is argument “holidays” required in =NETWORKDAYS?

Question 9 of 10 9/10

How many arguments does =NETWORKDAYS have in total?

Question 10 of 10 10/10

In =NETWORKDAYS, which is argument #2?

Click a question to see the answer.

1. Since which Excel version is =NETWORKDAYS available?

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

Explanation: Version: “All versions”.

2. Which is the correct syntax of =NETWORKDAYS?

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

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

3. Which statement about =NETWORKDAYS is correct?

A. Requires add-in
B. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2012,5,23) for the 23rd day of May, 2012. Problems can occur if dates are entered as text.
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, 2012 is serial number 40909 because it is 40,909 days after January 1, 1900.
D. 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. ✓

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.

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

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

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

5. In =NETWORKDAYS, which is argument #3?

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

Explanation: Argument #3 is “holidays”.

6. What is the type of argument “end_date” in =NETWORKDAYS?

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

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

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

A. end_date
B. start_date ✓
C. criteria
D. range

Explanation: Argument #1 is “start_date”.

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

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

Explanation: “holidays” is optional.

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

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

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

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

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

Explanation: Argument #2 is “end_date”.