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

Quiz =DATEDIF — 15 Questions

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

Question 1 of 15 1/15

What is the type of argument “unit” in =DATEDIF?

Question 2 of 15 2/15

Which formula is a valid example of =DATEDIF?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

In =DATEDIF, which is argument #2?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Is argument “unit” required in =DATEDIF?

Question 7 of 15 7/15

Does =DATEDIF return a dynamic array?

Question 8 of 15 8/15

Is argument “end_date” required in =DATEDIF?

Question 9 of 15 9/15

Is argument “start_date” required in =DATEDIF?

Question 10 of 15 10/15

Which function is NOT related to =DATEDIF?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Which statement about =DATEDIF is correct?

Question 13 of 15 13/15

How many arguments does =DATEDIF have in total?

Question 14 of 15 14/15

Which is the correct syntax of =DATEDIF?

Question 15 of 15 15/15

How many optional arguments does =DATEDIF have?

Click a question to see the answer.

1. What is the type of argument “unit” in =DATEDIF?

A. Number
B. Array
C. Text ✓
D. Logical

Explanation: Type of “unit” is “Text”.

2. Which formula is a valid example of =DATEDIF?

A. =DATEDIF(A2, TODAY(), "Y") ✓
B. =TODAY(A2, TODAY(), "Y")
C. =DATEDIF(A2, TODAY(), "Y", 0)
D. DATEDIF(A2, TODAY(), "Y")

Explanation: Correct example: =DATEDIF(A2, TODAY(), "Y")

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

A. Swap the two dates and check the unit ✓
B. Only works in old versions
C. Select entire column for best performance
D. Text is always ignored

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

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

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

Explanation: Argument #2 is “end_date”.

5. What is the type of argument “start_date” in =DATEDIF?

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

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

6. Is argument “unit” required in =DATEDIF?

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

Explanation: “unit” is required.

7. Does =DATEDIF return a dynamic array?

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

Explanation: DATEDIF does not spill.

8. Is argument “end_date” required in =DATEDIF?

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

Explanation: “end_date” is required.

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

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

Explanation: “start_date” is required.

10. Which function is NOT related to =DATEDIF?

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

Explanation: “DMAX” is not related to DATEDIF.

11. What is the type of argument “end_date” in =DATEDIF?

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

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

12. Which statement about =DATEDIF is correct?

A. Output is always a dynamic array
B. Select entire column for best performance
C. Text is always ignored
D. 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. ✓

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.

13. How many arguments does =DATEDIF have in total?

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

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

14. 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)

15. How many optional arguments does =DATEDIF have?

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

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