In Excel, We use the ______ function to return the number of whole days between start_data and end_data.
In Excel, We use the ______ function to return the number of whole days between start_data and end_data.
Explanation
The DATEDIF() function is used to get days, months, or years between two dates.
Syntax: =DATEDIF (start_date, end_date, unit).
Additional information:
DATEDIFF()
The DATEDIFF() function returns the difference between two dates.
Syntax. DATEDIFF(interval, date1, date2).
*
DAYSBETWEEN
The daysBetween function takes startDateValue and endDateValue
Syntax. daysBetween( date1 , date2 ).