How do I subtract dates to get a number in years or years & month

How do I subtract dates to get a number in years or years & month

Post by anVkZ » Sun, 27 Aug 2006 03:33:01


Say I wanted to subtract 1/01/2005 from 6/30/2006 where I would get 1.5
years. Anybody know?
 
 
 

How do I subtract dates to get a number in years or years & month

Post by QmFyYiBSZW » Sun, 27 Aug 2006 03:46:02

How about

=(A2-A1)/365

And format to numeric.

 
 
 

How do I subtract dates to get a number in years or years & month

Post by Dave Peter » Sun, 27 Aug 2006 04:02:10


Chip Pearson has some very nice notes at:
http://www.yqcomputer.com/



--

Dave Peterson