=(YEAR(B7)-YEAR($B$6))+((MONTH(B7)-MONTH($B$6))/12)

is this the easiest way to calculate number of years(including fractions)
between two dates?

I thought =YEAR(B7)-YEAR($B$6) would have done it
if b7 = 3/12/1999 and b6 = 1/12/1998 the answer is 1.00
so it's apparently just rounding the number to whole years

the first formula seems to work but I didn't think it would have to be that
complicated
thanks
Mark