Excel Formula Counting Months Between Dates. This will give you the number of years between the two dates. So we just put 1 on the end to increase the answer by 1.
The formula is in F9. In this example the start date is in cell D9 and the end date is in E9. You can use this formula to find the number of months between two dates.
DATEDIF B2TODAY ymm denotes months between dates ignoring days and years with string m attached to the number.
This will give you the number of years between the two dates. If the start and end dates are in the same month the formula returns 0. On the Ablebits Tools tab in the Date Time group click Date Time Wizard. Select the cell in which you want to insert the formula.