In attempt to create an editable database for an investment account utilizing
XIRR, I found that I only know how to get XIRR to work if I put the "present
value" and "present date" in the same columns, or rows, as the other data
(previous invested amounts and their dates). I understand I can indiviually
enter the actual values into the XIRR but that would take forever.
I want to have a separate collumn for "present value" and "present date".

How do I write XIRR for the following?
A B C D
1 Invested Date Pres Val Pres Date
2 $99 01/02/04 XIRR 03/05/04
3 $125 11/06/05 XIRR 01/19/06
4 $57 03/19/06 XIRR 03/20/06

Thanks
tloano