Date & Time =DAYS(end_date, start_date)

Quiz =DAYS — 15 Questions

15 quiz questions about =DAYS — test syntax, arguments, examples & errors!

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

← DAYS ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “end_date” in =DAYS?

Question 2 of 15 2/15

How many optional arguments does =DAYS have?

Question 3 of 15 3/15

Does =DAYS return a dynamic array?

Question 4 of 15 4/15

Which use case fits =DAYS?

Question 5 of 15 5/15

What is the fix for #NUM! in =DAYS?

Question 6 of 15 6/15

Is =DAYS volatile?

Question 7 of 15 7/15

What usually causes #NUM! in =DAYS?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Which category does =DAYS belong to?

Question 10 of 15 10/15

Which statement about =DAYS is correct?

Question 11 of 15 11/15

What usually causes #VALUE! in =DAYS?

Question 12 of 15 12/15

Is argument “end_date” required in =DAYS?

Question 13 of 15 13/15

Since which Excel version is =DAYS available?

Question 14 of 15 14/15

Which formula is a valid example of =DAYS?

Question 15 of 15 15/15

Which function is NOT related to =DAYS?

Click a question to see the answer.

1. What is the type of argument “end_date” in =DAYS?

A. Any type ✓
B. Logical
C. Reference
D. Mixed

Explanation: Type of “end_date” is “Any type”.

2. How many optional arguments does =DAYS have?

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

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

3. Does =DAYS return a dynamic array?

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

Explanation: DAYS does not spill.

4. Which use case fits =DAYS?

A. Date & Time Calculations ✓
B. Text Manipulation
C. Reporting
D. Daily Tasks

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

5. What is the fix for #NUM! in =DAYS?

A. Select entire column for best performance
B. Only works in old versions
C. Output is always a dynamic array
D. مطمئن شوید شماره سریال تاریخ‌ها در محدوده تاریخ‌های پشتیبانی‌شده اکسل هستند؛ تاریخ‌ها را با تابع DATE وارد کنید. ✓

Explanation: If date arguments are numeric values that fall outside the range of valid dates, DAYS returns the #NUM! error value. — Fix: مطمئن شوید شماره سریال تاریخ‌ها در محدوده تاریخ‌های پشتیبانی‌شده اکسل هستند؛ تاریخ‌ها را با تابع DATE وارد کنید.

6. Is =DAYS volatile?

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

Explanation: DAYS is not volatile.

7. What usually causes #NUM! in =DAYS?

A. Output is always a dynamic array
B. If date arguments are numeric values that fall outside the range of valid dates, DAYS returns the #NUM! error value. ✓
C. Select entire column for best performance
D. Only works in old versions

8. What is the type of argument “start_date” in =DAYS?

A. Mixed
B. Any type ✓
C. Text
D. Number

Explanation: Type of “start_date” is “Any type”.

9. Which category does =DAYS belong to?

A. Information
B. Date & Time ✓
C. Lookup & Reference
D. Math & Trig

Explanation: Category is “Date & Time”.

10. Which statement about =DAYS is correct?

A. Output is always a dynamic array
B. Select entire column for best performance
C. Only works in old versions
D. If both date arguments are numbers, DAYS uses EndDate–StartDate to calculate the number of days in between both dates. ✓

Explanation: Correct: If both date arguments are numbers, DAYS uses EndDate–StartDate to calculate the number of days in between both dates.

11. What usually causes #VALUE! in =DAYS?

A. Select entire column for best performance
B. Text is always ignored
C. If date arguments are strings that cannot be parsed as valid dates, DAYS returns the #VALUE! error value. ✓
D. Output is always a dynamic array

Explanation: If date arguments are strings that cannot be parsed as valid dates, DAYS returns the #VALUE! error value. — Fix: Use a real date

12. Is argument “end_date” required in =DAYS?

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

Explanation: “end_date” is required.

13. Since which Excel version is =DAYS available?

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

Explanation: Version: “Excel 2013”.

14. Which formula is a valid example of =DAYS?

A. =DAYS("15-MAR-2021","1-FEB-2021") ✓
B. DAYS("15-MAR-2021","1-FEB-2021")
C. =DAYS("15-MAR-2021","1-FEB-2021", 0)
D. =DATE("15-MAR-2021","1-FEB-2021")

Explanation: Correct example: =DAYS("15-MAR-2021","1-FEB-2021")

15. Which function is NOT related to =DAYS?

A. CHAR ✓
B. DATEDIF
C. TODAY
D. DATE

Explanation: “CHAR” is not related to DAYS.