Question: how to calculate tenure in years months and days in excel?
Answer: Use DATEDIF to find the total years. In this example, the start date is in cell D17, and the end date is in E17. ... 
Use DATEDIF again with “ym” to find months. ... 
Use a different formula to find days. ... 
Optional: Combine three formulas in one.