Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
XIRR
XIRR is the date-aware counterpart to IRR: it computes the return rate that makes the net present value of cash flows (discounted by exact day counts) equal to zero. Use it when investment cash flows occur on irregular dates rather than at fixed periodic intervals.
Excel
=XIRR(B2:B5,A2:A5,0.1)Google Sheets
=XIRR(B2:B5,A2:A5,0.1)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1List cash flow dates in column A and corresponding amounts in column B; include the initial outflow as a negative value.
- 2Type =XIRR(values, dates, [guess]) — e.g. =XIRR(B2:B5,A2:A5,0.1).
- 3If the function returns an error, try a different guess value, or verify that there is at least one positive and one negative cash flow.
Need a version for your data?
Try: “Calculate IRR for an investment where I made deposits and withdrawals on random dates”