If you look in Excel Help for XIRR you will see:

"...
If this function is not available, run the Setup program to install
the Analysis ToolPak. After you install the Analysis ToolPak, you must
enable it by using the Add-Ins command on the Tools menu.
..."

And you can click on How? below this message to get full details of
how to go about this.

Hope this helps.

Pete

On Jan 3, 6:03*pm, jIM wrote:
I do not have XIRR function to calculate IRR for my investments. *I
only deposit, do not withdraw, can someone help me with formula or
installing XIRR.

The formula others use:

([old value-.5* deposits]/[end value+.5*deposits])-1

this worked well when combining 6 accounts (two 401k, 2 Roth IRA, 2
Rollover IRA), = 4.7% IRR, but did not do well with each sub account
(no account had less than a 30% IRR).

suggestions?