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.

=EDATE("8/14/2018",-6)

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:

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

See this example where we add a year to the date listed in cell A1.