# Excel XIRR Function

The Excel XIRR function is a financial function that returns the internal rate of return (IRR) for a series of cash flows that occur at irregular intervals.

**values**- Array or reference to cells that contain cash flows.**dates**- Dates that correspond to cash flows, in any order.**guess**- [optional] An estimate for expected IRR. Default is .1 (10%).

The XIRR function calculates the internal rate of return for series of cash flows that occur at irregular intervals. To calculate the internal rate of return for a series of regular, periodic cash flows, use the IRR function.

Payments are expressed as negative values and income as positive values. If the first value is a cost or payment, it must be a negative value. Subsequent payments are discounted based on a 365-day year.

Dates must be valid Excel dates and may occur in any order. Use the DATE function to enter dates precisely if needed.

Excel uses iteration to arrive at a result, starting with the guess (if provided) or with .1 (10%) if not. If an accurate rate can't be calculated after a fixed number of iterations, the #NUM error is returned.

### Notes

- The
*values*array must contain at least one positive value and one negative value. *Dates*must be valid Excel dates that correspond to*values**Dates*do not need to be in chronological order.

## Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.