10 years 10 months. In E2 enter the formula DATEDIF C2D2y years DATEDIF C2D2ym months DATEDIF C2D2md dates. In cell A3 write the following formula DATEDIFA1A2y.
Formula INTTODAY-A336525 years INTMODTODAY-A436525112 months and INTMODTODAY-A43043751304375 days is not the same like formula.
Cell C4 shown contains the following formula. If we want to show the Tenure like XX years and XX months we need to update the formula. In D2 enter the formula DATEDIF B2NOW Y years DATEDIF B2NOW YM months. In this example the start date is in cell D17 and the end date is in E17.