Is it possible to use the IRR function to calculate only a subset of the cashflow?
For example, in Jul 18 I'm looking to calculate the IRR of the cashflow from the beginning to Jul 18 and then on Aug 18 it will be from the beginning to Aug 18.
In excel you can simply have the formula as IRR($H2:I2) and apply that across the entire row.