I think xirr is in the analysis toolpak addin.

--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
I am trying to calculate CAGR by using the suggested fromula XIRR but
contnue
to get #NAME? as an answer and not the xx%. Is this formula correct?