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 fix for #NUM! in =DAYS?

Question 2 of 15 2/15

How many optional arguments does =DAYS have?

Question 3 of 15 3/15

Which category does =DAYS belong to?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Which function is related to =DAYS?

Question 6 of 15 6/15

Is =DAYS volatile?

Question 7 of 15 7/15

Which statement about =DAYS is correct?

Question 8 of 15 8/15

In =DAYS, which is argument #2?

Question 9 of 15 9/15

What usually causes #VALUE! in =DAYS?

Question 10 of 15 10/15

How many arguments does =DAYS have in total?

Question 11 of 15 11/15

Which use case fits =DAYS?

Question 12 of 15 12/15

Which is the correct syntax of =DAYS?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Is argument “start_date” required in =DAYS?

Question 15 of 15 15/15

Does =DAYS return a dynamic array?

Click a question to see the answer.

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

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

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

2. How many optional arguments does =DAYS have?

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

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

3. Which category does =DAYS belong to?

A. Engineering
B. Date & Time ✓
C. Compatibility
D. Cube

Explanation: Category is “Date & Time”.

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

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

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

5. Which function is related to =DAYS?

A. DATE ✓
B. ISTEXT
C. INFO
D. CHIINV

Explanation: “DATE” is related to DAYS.

6. Is =DAYS volatile?

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

Explanation: DAYS is not volatile.

7. Which statement about =DAYS is correct?

A. Output is always a dynamic array
B. Volatile and recalculates every time
C. Requires add-in
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.

8. In =DAYS, which is argument #2?

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

Explanation: Argument #2 is “start_date”.

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

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

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

10. How many arguments does =DAYS have in total?

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

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

11. Which use case fits =DAYS?

A. Worksheet Info & Navigation
B. Lookup & Retrieval
C. Date & Time Calculations ✓
D. Scientific & Unit Conversion

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

12. Which is the correct syntax of =DAYS?

A. =DAYS(end_date, start_date) ✓
B. =DAYS(end_date, start_date, 0)
C. =DATE(end_date, start_date)
D. DAYS(end_date, start_date)

Explanation: Correct syntax: =DAYS(end_date, start_date)

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

A. Logical
B. Value
C. Text
D. Any type ✓

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

14. Is argument “start_date” required in =DAYS?

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

Explanation: “start_date” is required.

15. Does =DAYS return a dynamic array?

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

Explanation: DAYS does not spill.