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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
Which is the correct syntax of =EDATE?
Explanation: Correct syntax: =EDATE(start_date, months)
Question 2 of 10
2/10
Which statement about =EDATE is correct?
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.
Question 3 of 10
3/10
Which use case fits =EDATE?
Explanation: Use case “Date & Time Calculations” fits EDATE.
Question 4 of 10
4/10
What is the type of argument “months” in =EDATE?
Explanation: Type of “months” is “Number”.
Question 5 of 10
5/10
Since which Excel version is =EDATE available?
Explanation: Version: “All versions”.
Question 6 of 10
6/10
In =EDATE, which is argument #2?
Explanation: Argument #2 is “months”.
Question 7 of 10
7/10
Which function is NOT related to =EDATE?
Explanation: “IMSEC” is not related to EDATE.
Question 8 of 10
8/10
In =EDATE, which is argument #1?
Explanation: Argument #1 is “start_date”.
Question 9 of 10
9/10
Is argument “start_date” required in =EDATE?
Explanation: “start_date” is required.
Question 10 of 10
10/10
Does =EDATE return a dynamic array?
Explanation: EDATE does not spill.