Counting time in Excel
If you want to know how many months or years to a date in Excel, here's how:
The EDATE formula can be used to count the number of months to or from a particular date.
In this example, the formula counts what date is six months before August 14, 2018. Removing the minus sign will give us a formula result of February 14, 2018.
With this DATE formula, we can add a value to either the month, day or year:
See this example where we add a year to the date listed in cell A1.