Skip to content

XIRR

FinancialExcel 2007

Internal rate of return for cash flows on specific (uneven) dates.

Syntax

XIRR(values, dates, [guess])

Examples

=XIRR(amounts, dates)

→ annualised return of an irregular SIP / portfolio

Related functions

IRRXNPV

More Financial functions

ACCRINTACCRINTMAMORDEGRCAMORLINCCOUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNCDCOUPNUMCOUPPCDCUMIPMTCUMPRINC

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.