Get each employee's tenure in whole years for review prep
Performance review packs need each employee's tenure shown as a whole number of years from their start date. DATEDIF with the "Y" unit returns exactly that — truncated to complete years, no fractions.
Calculate employee tenure in years
Practice using DATEDIF to solve a real hr & operations problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
HR needs to calculate each employee's tenure for the annual review cycle. You need to find the number of complete years between their start date and today, for every employee on the roster.
In C2, return the number of complete years between the start date in B2 and today's date. Use the "Y" unit code. Drag the formula down through every employee.
DATEDIF returns the difference between two dates in whole years, months, or days depending on the unit code you pass. The workhorse for employee tenure, customer age, and project duration. Excel doesn't show it in autocomplete but it still ships in every version.
DATEDIF(start_date, end_date, unit)Try the formula first. Hints cost CP for a reason.