I need to implement a dynamic XIRR formula that exclude all the cash flow which related dates are lower than a reference date.
At the moment I have this construction which helps calculating XIRR based on condition and non-adjacent cells.
XIRR(VSTACK(-INDEX(INPUT!$C:$C,N(IF(1,MODE.MULT(IF(INPUT!$E$2:$E$101=$A$4,ROW(INPUT!$C$2:$C$101)*{1,1}))))),G4),VSTACK(INDEX(INPUT!$B:$B,N(IF(1,MODE.MULT(IF(INPUT!$E$2:$E$101=$A$4,ROW(INPUT!$C$2:$C$101)*{1,1}))))),G$2))