I am trying to calculate the XIRR of multiple cash flows from a pivot table. Is there an efficient way to calculate the XIRR of all investments without having to locate the first cash flow/date using the XIRR function? The highlighted figures are the initial cash flow amount and date of the first flow.
Thanks!
Thanks!