Calculating a Rolling IRR in Excel

Question

I have two columns that I'd like to use to calculate a rolling monthly IRR with. The data looks like this:

Date          Net Cash Flow   Principal    IRR
2023-01-31    0               0            idk
2023-02-28    -62             62           ...
2023-03-31    1.4             62           
2023-04-30    1.3             62
2023-05-31    1.3             62
2023-06-30    -62             124
...           ...             ...

For the duration of the fund, assuming the principal is fully repaid, I want to generate a rolling IRR that will continue to recalculate each month. It would essentially be a "point in time" IRR that would change when additional cash flows were added, the principal was written down, or the principal's value increased. How can I accomplish this with just one column (or helper columns)?

Answer 1

I'm assuming a little bit here, but wouldn't get the desired result come from having the IRR formula always start at cell R2C2 and terminate at the corresponding cell RC3?