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

Which function is NOT related to =DATEDIF?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which category does =DATEDIF belong to?

Question 4 of 15 4/15

Is argument “unit” required in =DATEDIF?

Question 5 of 15 5/15

How many optional arguments does =DATEDIF have?

Question 6 of 15 6/15

Is argument “end_date” required in =DATEDIF?

Question 7 of 15 7/15

Is =DATEDIF volatile?

Question 8 of 15 8/15

In =DATEDIF, which is argument #1?

Question 9 of 15 9/15

What is the output type of =DATEDIF?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Since which Excel version is =DATEDIF available?

Question 12 of 15 12/15

In =DATEDIF, which is argument #2?

Question 13 of 15 13/15

Which statement about =DATEDIF is correct?

Question 14 of 15 14/15

Which is the correct syntax of =DATEDIF?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which function is NOT related to =DATEDIF?

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

Explanation: “GAMMALN” is not related to DATEDIF.

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

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

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

3. Which category does =DATEDIF belong to?

A. Information
B. Text
C. Logical
D. Date & Time ✓

Explanation: Category is “Date & Time”.

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

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

Explanation: “unit” is required.

5. How many optional arguments does =DATEDIF have?

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

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

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

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

Explanation: “end_date” is required.

7. Is =DATEDIF volatile?

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

Explanation: DATEDIF is not volatile.

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

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

Explanation: Argument #1 is “start_date”.

9. What is the output type of =DATEDIF?

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

Explanation: Output is “Number”.

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

A. Output is always a dynamic array
B. Text is always ignored
C. Swap the two dates and check the unit ✓
D. Volatile and recalculates every time

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

11. Since which Excel version is =DATEDIF available?

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

Explanation: Version: “All versions”.

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

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

Explanation: Argument #2 is “end_date”.

13. Which statement about =DATEDIF is correct?

A. Only works in old versions
B. Requires add-in
C. The DATEDIF function is useful in formulas where you need to calculate an age.
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.

14. Which is the correct syntax of =DATEDIF?

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

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

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

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

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