Counting time in Excel

Counting time in Excel

August 15, 2018

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.  





Please reload

Contact Me With Your Litigation Support Questions:

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with