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

Which category does =DATEDIF belong to?

Question 2 of 10 2/10

Which statement about =DATEDIF is correct?

Question 3 of 10 3/10

How many arguments does =DATEDIF have in total?

Question 4 of 10 4/10

What usually causes #NUM! in =DATEDIF?

Question 5 of 10 5/10

Which formula is a valid example of =DATEDIF?

Question 6 of 10 6/10

Is argument “end_date” required in =DATEDIF?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

In =DATEDIF, which is argument #1?

Question 9 of 10 9/10

In =DATEDIF, which is argument #3?

Question 10 of 10 10/10

How many required arguments does =DATEDIF have?

Click a question to see the answer.

1. Which category does =DATEDIF belong to?

A. Web
B. Compatibility
C. Information
D. Date & Time ✓

Explanation: Category is “Date & Time”.

2. Which statement about =DATEDIF is correct?

A. Volatile and recalculates every time
B. 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. ✓
C. Only works in old versions
D. Output is always a dynamic array

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.

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

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

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

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

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

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

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

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

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

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

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

Explanation: “end_date” is required.

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

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

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

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

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

Explanation: Argument #1 is “start_date”.

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

A. unit ✓
B. value
C. range
D. end_date

Explanation: Argument #3 is “unit”.

10. How many required arguments does =DATEDIF have?

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

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