Financial
XIRR
Rate of return for cash flows on arbitrary dates.
Syntax
XIRR(values, dates, [guess])Example: =XIRR(B2:B6,A2:A6)
Available in: All versions
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in D2: =XIRR(B2:B5,A2:A5)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Cash flow | Result | |
| 2 | 1/1/2026 | -10000 | 0.247820893036 | |
| 3 | 6/1/2026 | 3000 | ||
| 4 | 1/1/2027 | 4500 | ||
| 5 | 6/1/2027 | 5000 |
Result in D2: 0.247820893036