Syntax. XIRR(Values,Dates,Estimated_Value)

Definition. This function returns the internal interest rate for a series of not-necessarily periodic payments in the intra-annual scope.


  • Values (required) The (actual and/or expected) surpluses from disbursements and deposits, arranged without gaps in a column. Each value stands for a date. Negative surpluses have a minus sign.

  • Dates (required) The dates for the surpluses. The order must correspond to the payments in the argument Values. The first date specifies the start of the evaluation. All others must be after this date (without necessarily being in a specific order). The error value #NUMBER! indicates that this requirement might not have been met.

  • Estimated_Value (optional) For mathematical ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.