MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Calculates the difference between two dates
A)SUMIF
B)VLOOKUP
C)COUNTIF
D)conditional formatting
E)DATEDIF
F)AVERAGE
G)HLOOKUP
H)TRANSPOSE
I)logical condition
J)SUM

Question

Quizplus · Accepted Answer

DATEDIF function is used to calculate the difference between two dates in days, months, or years.

Example: =DATEDIF(start_date,end_date,"interval")

(start_date and end_date are the dates you want to calculate the difference between, and "interval" specifies the unit of time you want to use for the calculation)

MATCHING Identify the Letter of the Choice That Best Matches the the Phrase