ƒx SheetOps
ƒx

Excel XIRR Formula

finance Difficulty:
One-Click Copy
=XIRR(values, dates, [guess])

Quick context

  • • Works in both Excel and Google Sheets.
  • • Use when you need consistent, auditable results.
  • • Copy the snippet above and adjust only the ranges.

When to use

Learn how to use the Excel XIRR Formula formula.

Why you need this

XIRR is essential when cash flows are irregular. Unlike IRR, which assumes equal time intervals, XIRR handles specific dates for each cash flow.

Use this for private equity returns, project ROI, or any investment with ad-hoc capital calls.

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.

Manual Risk Detected

XIRR fails if dates are formatted as text. Hardcoded arrays hide logic errors.

See finance Alternatives