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

Is argument “months” required in =EDATE?

Question 2 of 10 2/10

What is the fix for #VALUE! in =EDATE?

Question 3 of 10 3/10

What usually causes #VALUE! in =EDATE?

Question 4 of 10 4/10

Which formula is a valid example of =EDATE?

Question 5 of 10 5/10

In =EDATE, which is argument #1?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

What is the output type of =EDATE?

Question 8 of 10 8/10

Which function is related to =EDATE?

Question 9 of 10 9/10

Which statement about =EDATE is correct?

Question 10 of 10 10/10

Which use case fits =EDATE?

Click a question to see the answer.

1. Is argument “months” required in =EDATE?

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

Explanation: “months” is required.

2. What is the fix for #VALUE! in =EDATE?

A. Only works in old versions
B. Select entire column for best performance
C. Text is always ignored
D. Check the two arguments ✓

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

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

A. Output is always a dynamic array
B. Select entire column for best performance
C. If start_date is not a valid date, EDATE returns the #VALUE! error value. ✓
D. Text is always ignored

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

4. Which formula is a valid example of =EDATE?

A. =TODAY(A2,1)
B. =EDATE(A2,1) ✓
C. EDATE(A2,1)
D. =EDATE(A2,1, 0)

Explanation: Correct example: =EDATE(A2,1)

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

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

Explanation: Argument #1 is “start_date”.

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

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

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

7. What is the output type of =EDATE?

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

Explanation: Output is “Date”.

8. Which function is related to =EDATE?

A. QUARTILE.EXC
B. GAMMAINV
C. IMDIV
D. TODAY ✓

Explanation: “TODAY” is related to EDATE.

9. Which statement about =EDATE is correct?

A. Only works in old versions
B. Select entire column for best performance
C. 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. ✓
D. If months is not an integer, it is truncated.

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.

10. Which use case fits =EDATE?

A. Date & Time Calculations ✓
B. Data Cleaning
C. Conditional Aggregation
D. Conditional Formatting & Validation

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