I am struggling with using the XIRR formula for larger data sets. For example, let's say I have 3 investments (A, B and C) I want to calculate returns on. I have a crude example below what the excel would look like. For each investment, I would like to use XIRR and then reference dates and cash flows. However, XIRR appears to be limited so that I need to adjust the cell references so that the reference starts at the initial investment date. Therefore, I cannot just copy and paste XIRR across the columns. I need to re-size each formula. This is a big inconvenience for a large dataset with a larger set of dates and many more investments to track.

Any ideas on how to get around this? (I am not a skilled VBA person fyi).

I would really appreciate a suggestion (big time saver here).

Date A B C
1-1-90 -50 0 0
2-5-95 100 -25 0
3-12-00 10 5 -40
12-31-04 10 50 55

XIRR=>