Date & Time =DATEDIF(start_date,end_date,unit)

Quiz =DATEDIF — 10 Questions

10 quiz questions about =DATEDIF — test syntax, arguments, examples & errors!

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

← DATEDIF ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the fix for #NUM! in =DATEDIF?

Question 2 of 10 2/10

Which function is related to =DATEDIF?

Question 3 of 10 3/10

Which statement about =DATEDIF is correct?

Question 4 of 10 4/10

Is argument “start_date” required in =DATEDIF?

Question 5 of 10 5/10

In =DATEDIF, which is argument #3?

Question 6 of 10 6/10

How many optional arguments does =DATEDIF have?

Question 7 of 10 7/10

Which is the correct syntax of =DATEDIF?

Question 8 of 10 8/10

In =DATEDIF, which is argument #2?

Question 9 of 10 9/10

What usually causes #NUM! in =DATEDIF?

Question 10 of 10 10/10

Which function is NOT related to =DATEDIF?

Click a question to see the answer.

1. What is the fix for #NUM! in =DATEDIF?

A. Requires add-in
B. Only works in old versions
C. Output is always a dynamic array
D. Swap the two dates and check the unit ✓

Explanation: If the start_date is greater than the end_date, the result will be #NUM!. — Fix: Swap the two dates and check the unit

2. Which function is related to =DATEDIF?

A. CSCH
B. TODAY ✓
C. FIELDVALUE
D. TRANSPOSE

Explanation: “TODAY” is related to DATEDIF.

3. Which statement about =DATEDIF is correct?

A. Dates are stored 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,447 days after January 1, 1900. ✓
B. Volatile and recalculates every time
C. Text is always ignored
D. Select entire column for best performance

Explanation: Correct: Dates are stored 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,447 days after January 1, 1900.

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

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

Explanation: “start_date” is required.

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

A. lookup_value
B. unit ✓
C. end_date
D. criteria

Explanation: Argument #3 is “unit”.

6. How many optional arguments does =DATEDIF have?

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

Explanation: =DATEDIF has 3 required, 0 optional (3 total).

7. Which is the correct syntax of =DATEDIF?

A. =DATEDIF(start_date,end_date,unit, 0)
B. =DATEDIF(start_date,end_date,unit) ✓
C. DATEDIF(start_date,end_date,unit)
D. =TODAY(start_date,end_date,unit)

Explanation: Correct syntax: =DATEDIF(start_date,end_date,unit)

8. In =DATEDIF, which is argument #2?

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

Explanation: Argument #2 is “end_date”.

9. What usually causes #NUM! in =DATEDIF?

A. Only works in old versions
B. If the start_date is greater than the end_date, the result will be #NUM!. ✓
C. Output is always a dynamic array
D. Requires add-in

Explanation: If the start_date is greater than the end_date, the result will be #NUM!. — Fix: Swap the two dates and check the unit

10. Which function is NOT related to =DATEDIF?

A. YEAR
B. DAYS
C. ADDRESS ✓
D. TODAY

Explanation: “ADDRESS” is not related to DATEDIF.