(Showing Draft Content)


This function calculates the internal rate of return for a schedule of cash flows that may not be periodic.


XIRR(values, dates, guess)


This function has these arguments:




Series of cash flows that correspond to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment


Schedule of payment dates that correspond to the cash flow payments in values


[Optional] Estimate of the internal rate of return that you guess is close to the result of this function; if omitted, the calculation uses 0.1 (10 percent)


For a schedule of cash flows that is periodic, use IRR. Numbers in dates are truncated to integers.

Both a positive and negative cash flow is required to prevent a #NUM! error.

The function returns an error in the following cases:

  • If dates is invalid, a #VALUE! error is returned.

  • If a number in dates precedes the starting date, a #NUM! error is returned.

  • If values and dates contain a different number of values, a #NUM! error is returned.

  • If the function can not find a result that works after 100 tries, a #NUM! error is returned.

Data Types

Accepts numeric data for values and guess, DateTime object data for dates. Returns numeric data.