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.