|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.