You're an HR analyst preparing a tenure report for the start of FY26. Columns A–C contain ten employees with their hire dates. The reporting "as of" date is 2026-01-01 (use this as a literal in your formula).
Your task:
- In column D (Years of Tenure), compute the completed full years between each employee's Hire Date and 2026-01-01. An employee whose hire-date anniversary has not yet occurred by 2026-01-01 should round DOWN.
Graded cells: D2 through D11.
Open this problem on a desktop to attempt it.