Calculate CAGR

Hi, Is there a function in excel 2007 to calculate CAGR, the Compound Annual Growth Rate?

I know the formula to calculate it, and I can do it, but in my case it's messy. I can't find a function to do it neatly. The number of years is not an integer.

Any ideas ?

Is there a way of defining my own functions in excel 2007 ?

Thx as always

K

Maybe these can help you.

Is there a way of defining my own functions in excel 2007 ?

Yes. Those are called User Defined Functions a.k.a. UDF's.