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

[jude]

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

 

[Barb Reinhardt]

How about

=(A2-A1)/365

And format to numeric.

 

[Dave Peterson]

Chip Pearson has some very nice notes at:
http://www.cpearson.com/excel/datedif.htm