Maybe like this: (assuming your data is in row 2)

=((C2-B2)/B2)/((TODAY()-A2)/365)

and format the cell containing this formula as percentage.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=480965