Hi Kathy,

Try this simpler formula:
=(100/65)^(1/((TODAY()-DATE(2002,4,1))/365))-1
My example assumes you bought the stock on 4/1/02 for $65 and sold it
today for $100. It should return a CAGR of 12.7%
You can subsitiute the prices and buy date with cell references.