Check out thisw link on the DateDif function...

http://www.cpearson.com/excel/datedif.htm
--
HTH...

Jim Thomlinson


"michelle" wrote:

I have a start date and an end date. I want to show the number of years and
months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1
yr 6 mos)