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.

=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.  

 

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com