DATEDIF Function

Freebeginner 15 min4 tasks0/54 pts

DATEDIF measures the gap between two dates in complete years ("Y"), months ("M") or days ("D"). It is the go-to for ages and tenure. It only counts completed units: 4 years and 7 months is 4 years.

Syntax

DATEDIF(start_date, end_date, unit)

Example: =DATEDIF(B2,C2,"Y") returns the whole years between the two dates.

Common mistakes

Putting the end date first (you get #NUM!).
Forgetting the unit text needs quotes.

TODAY Function DAYS Function