Excel Function

DATEDIF

Returns difference between dates in selected unit.

DATEDIF(start_date, end_date, unit)

Arguments

start_date

Required

Enter a date/reference-related value.

end_date

Required

Enter a date/reference-related value.

unit

Required

Set DATEDIF unit: "Y" years, "M" months, "D" days, plus "MD", "YM", "YD".

Practice Preview

calculate and display date/time values. Use DATEDIF to Returns difference between dates in selected unit. use "D" for unit. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=DATEDIF(B2, C2, "D")

Practice This Function

Practice in Sequential Mode Back to Function List