XIRR Function
Calculates the rate of return for cash flows on specific dates.
Category
Financial
Available in
All versions, Microsoft 365
Returns
An annual rate of return
Overview
XIRR is IRR for real calendars: it finds the annual rate at which XNPV equals zero, so cash flows can fall on any dates.
It's the go-to measure for investments, private-equity deals and projects with uneven timing.
Syntax
=XIRR(values, dates, [guess])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| values | Yes | The cash flows, with at least one negative and one positive. |
| dates | Yes | The matching dates. |
| guess | No | A starting guess. Omitted = 10%. |
Examples
Example 1 — Dated store returns
The store schedule with real dates.
B7fx=XIRR(B2:B6,A2:A6)
| A | B | |
|---|---|---|
| 1 | Date | Cash flow |
| 2 | 4/1/2026 | -$150,000 |
| 3 | 9/15/2026 | $40,000 |
| 4 | 6/30/2027 | $50,000 |
| 5 | 3/31/2028 | $60,000 |
| 6 | 12/15/2028 | $55,000 |
| 7 | XIRR | 20.94% |
Much higher than the 12.96% IRR because the cash arrives well before each anniversary.
Common mistakes
- #NUM! error. Values need both signs, and no date can come before the first one.
- Text dates. Dates typed as text cause #VALUE!. Convert them with DATEVALUE.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.