If you want to find the time between two dates,you would use the ________ function.
A) TIME
B) DATE
C) DATEDIF
D) WEEKNUM

Question

Quizplus · Accepted Answer

The DATEDIF function is specifically designed to calculate the difference between two dates in years, months, or days. It is the best choice for finding the time between two dates.

The TIME function is used to create a time value from hours, minutes, and seconds, and is not suited for finding the time between two dates.

The DATE function is used to create a date value from year, month, and day values, and is not suited for finding the time between two dates.

The WEEKNUM function is used to determine the week number of a specified date, and is not suited for finding the time between two dates.

If You Want to Find the Time Between Two Dates,you