DATEDIF Function
Purpose
Calculates the number of days, months, or years between two dates.
Syntax
EXCEL
=DATEDIF(start_date, end_date, unit)
"D": Full days."M": Complete calendar months."Y": Complete calendar years.