Date & Time =EDATE(start_date, months)

Quiz =EDATE — 15 Questions

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

Question 1 of 15 1/15

Which formula is a valid example of =EDATE?

Question 2 of 15 2/15

Is argument “start_date” required in =EDATE?

Question 3 of 15 3/15

Which function is NOT related to =EDATE?

Question 4 of 15 4/15

Which use case fits =EDATE?

Question 5 of 15 5/15

How many optional arguments does =EDATE have?

Question 6 of 15 6/15

What usually causes #VALUE! in =EDATE?

Question 7 of 15 7/15

In =EDATE, which is argument #2?

Question 8 of 15 8/15

How many arguments does =EDATE have in total?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Which statement about =EDATE is correct?

Question 11 of 15 11/15

Is argument “months” required in =EDATE?

Question 12 of 15 12/15

Which category does =EDATE belong to?

Question 13 of 15 13/15

Since which Excel version is =EDATE available?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

What is the output type of =EDATE?

Click a question to see the answer.

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

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

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

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

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

Explanation: “start_date” is required.

3. Which function is NOT related to =EDATE?

A. COVARIANCE.P ✓
B. DATE
C. TODAY
D. EOMONTH

Explanation: “COVARIANCE.P” is not related to EDATE.

4. Which use case fits =EDATE?

A. Scientific & Unit Conversion
B. Securities & Bonds
C. Forecasting & Trends
D. Date & Time Calculations ✓

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

5. How many optional arguments does =EDATE have?

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

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

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

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

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

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

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

Explanation: Argument #2 is “months”.

8. How many arguments does =EDATE have in total?

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

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

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

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

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

10. Which statement about =EDATE is correct?

A. 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. ✓
B. Volatile and recalculates every time
C. Only works in old versions
D. Requires add-in

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.

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

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

Explanation: “months” is required.

12. Which category does =EDATE belong to?

A. Web
B. Date & Time ✓
C. Lookup & Reference
D. Engineering

Explanation: Category is “Date & Time”.

13. Since which Excel version is =EDATE available?

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

Explanation: Version: “All versions”.

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

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

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

15. What is the output type of =EDATE?

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

Explanation: Output is “Date”.