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

What is the output type of =EDATE?

Question 3 of 15 3/15

How many arguments does =EDATE have in total?

Question 4 of 15 4/15

Is argument “months” required in =EDATE?

Question 5 of 15 5/15

Which category does =EDATE belong to?

Question 6 of 15 6/15

Which function is NOT related to =EDATE?

Question 7 of 15 7/15

Which statement about =EDATE is correct?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Which use case fits =EDATE?

Question 10 of 15 10/15

How many required arguments does =EDATE have?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

What usually causes #VALUE! in =EDATE?

Question 13 of 15 13/15

Which function is related to =EDATE?

Question 14 of 15 14/15

Since which Excel version is =EDATE available?

Question 15 of 15 15/15

Is =EDATE volatile?

Click a question to see the answer.

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

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

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

2. What is the output type of =EDATE?

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

Explanation: Output is “Date”.

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

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

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

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

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

Explanation: “months” is required.

5. Which category does =EDATE belong to?

A. Database
B. Engineering
C. Date & Time ✓
D. Math & Trig

Explanation: Category is “Date & Time”.

6. Which function is NOT related to =EDATE?

A. EOMONTH
B. TODAY
C. DATE
D. IMSECH ✓

Explanation: “IMSECH” is not related to EDATE.

7. Which statement about =EDATE is correct?

A. If months is not an integer, it is truncated.
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. Only works in old versions

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.

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

A. Requires add-in
B. Select entire column for best performance
C. Check the two arguments ✓
D. Only works in old versions

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

9. Which use case fits =EDATE?

A. Ranking & Top N
B. Worksheet Info & Navigation
C. Date & Time Calculations ✓
D. Dynamic Ranges & Dashboards

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

10. How many required arguments does =EDATE have?

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

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

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

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

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

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

A. Text is always ignored
B. Select entire column for best performance
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

13. Which function is related to =EDATE?

A. AVEDEV
B. NETWORKDAYS
C. TODAY ✓
D. MROUND

Explanation: “TODAY” is related to EDATE.

14. Since which Excel version is =EDATE available?

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

Explanation: Version: “All versions”.

15. Is =EDATE volatile?

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

Explanation: EDATE is not volatile.