IRR formula

Giganews Newsgroups
Subject: IRR formula
Posted by:  Jeff
Date: Fri, 26 May 2006


I have dates in column A, and payments into a fund in column B.  The
payments are not uniform and the dates are random, so I want to calculate the
IRR, based on todays date.  One way is to put in column C the payment and the

B1*(1+$D$1^(Today()-A1)/365)) for all the rows and do a goal seek on D1.
The goal seek on the value today, which I know + comes from another source.

Is there a way to do this in one formula, I tried using arrays and
sumproduct but could not figure anything out?

Thanks for your help.