# XIRR

## Content

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

## Syntax

`XIRR(values, dates, guess)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *values* | 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 |
| *dates* | Schedule of payment dates that correspond to the cash flow payments in *values* |
| *guess* | [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) |

## Remarks

For a schedule of cash flows that is periodic, use [IRR](/spreadjs/docs/v16/formulareference/FormulaFunctions/financial-functions/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.

## Examples

`XIRR(B2:B6,C2:C6,0.2)`