Date & Time =EDATE(start_date, months)

Quiz =EDATE — 10 Questions

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

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

← EDATE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =EDATE, which is argument #2?

Question 2 of 10 2/10

Which statement about =EDATE is correct?

Question 3 of 10 3/10

In =EDATE, which is argument #1?

Question 4 of 10 4/10

Which use case fits =EDATE?

Question 5 of 10 5/10

Is argument “start_date” required in =EDATE?

Question 6 of 10 6/10

Which is the correct syntax of =EDATE?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

What is the type of argument “months” in =EDATE?

Question 9 of 10 9/10

How many optional arguments does =EDATE have?

Question 10 of 10 10/10

What usually causes #VALUE! in =EDATE?

Click a question to see the answer.

1. In =EDATE, which is argument #2?

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

Explanation: Argument #2 is “months”.

2. Which statement about =EDATE is correct?

A. Output is always a dynamic array
B. 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, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. ✓
C. Select entire column for best performance
D. Volatile and recalculates every time

Explanation: Correct: 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, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.

3. In =EDATE, which is argument #1?

A. months
B. range
C. value
D. start_date ✓

Explanation: Argument #1 is “start_date”.

4. Which use case fits =EDATE?

A. Rounding & Numeric
B. Reporting
C. Error Handling
D. Date & Time Calculations ✓

Explanation: Use case “Date & Time Calculations” fits EDATE.

5. Is argument “start_date” required in =EDATE?

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

Explanation: “start_date” is required.

6. Which is the correct syntax of =EDATE?

A. =TODAY(start_date, months)
B. =EDATE(start_date, months, 0)
C. EDATE(start_date, months)
D. =EDATE(start_date, months) ✓

Explanation: Correct syntax: =EDATE(start_date, months)

7. What is the type of argument “start_date” in =EDATE?

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

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

8. What is the type of argument “months” in =EDATE?

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

Explanation: Type of “months” is “Number”.

9. How many optional arguments does =EDATE have?

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

Explanation: =EDATE has 2 required, 0 optional (2 total).

10. What usually causes #VALUE! in =EDATE?

A. Output is always a dynamic array
B. If start_date is not a valid date, EDATE returns the #VALUE! error value. ✓
C. Requires add-in
D. Volatile and recalculates every time

Explanation: If start_date is not a valid date, EDATE returns the #VALUE! error value. — Fix: Check the two arguments