Annual Return

[mrr2]

Hi, can someone help me how to calculate the annualized return based on 3 years worth of returns? is there a quick formula that can do this?
thank you so much in advance

Workbook3.xlsx

[Ace_XL]

I presume its 24 months of return that you have in the sample worksheet. Is this what you are after (hopefully)?

=AVERAGE(B1:B24)*COUNT(A1:A24)/12

[mrr2]

thanks Ace_XL