How do I compute annual rate of return in Excel?
I have two columns: date and value of an investment on that date.
I want to select a date and compute the rate of return on the investment for
the prior year leading up to the selected date. Is there a possible for this?
|