# 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* | [Required] 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* | [Required] 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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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.

## Examples

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