Calculate Employee Tenure

Use DATEDIF to count complete years (and months) of service.

You will learn to

• Use DATEDIF with "Y" and "YM" units

How it works

DATEDIF(start, end, unit) returns the difference between two dates in complete years ("Y"), months ("M") or days ("D"). "YM" gives the leftover months after full years.

=DATEDIF(B2,C2,"Y")