Which MS excel function calculates the no of days between 2 dates?1. G

1.	Which MS excel function calculates the no of days between 2 dates?1. Gap2. Dates3. Days4. Days 3605. SPAN
Answer» Correct Answer - Option 3 : Days The correct answer is Days. The Excel DAYS function returns the number of days between two dates. With a start date in A1 and an end date in B1, =DAYS(B1, A1) will return the days between the two dates. Purpose: Get days between dates. Return value: A number representing days. Syntax: =DAYS (end_date, start_date) Arguments: end_date - The end date. start_date - The start date. Usage notes: The DAYS function returns the number of days between two dates. Both dates must be valid Excel dates or text values that can be parsed as dates. The DAYS function only works with whole numbers, fractional time values are ignored. If a start and end date are reversed, DAYS returns a negative number. The DAYS function returns all days between two dates, to calculate working days between dates, see the NETWORKDAYS function.

Which MS excel function calculates the no of days between 2 dates?1. Gap2. Dates3. Days4. Days 3605. SPAN

Answer» Correct Answer - Option 3 : Days

The correct answer is Days.

The Excel DAYS function returns the number of days between two dates.
With a start date in A1 and an end date in B1, =DAYS(B1, A1) will return the days between the two dates.
Purpose: Get days between dates.
Return value: A number representing days.
Syntax: =DAYS (end_date, start_date)
Arguments:
- end_date - The end date.
- start_date - The start date.
Usage notes:
- The DAYS function returns the number of days between two dates.
- Both dates must be valid Excel dates or text values that can be parsed as dates.
- The DAYS function only works with whole numbers, fractional time values are ignored.
- If a start and end date are reversed, DAYS returns a negative number.
- The DAYS function returns all days between two dates, to calculate working days between dates, see the NETWORKDAYS function.