Hi,

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
formula

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.