I need to compute cell by cell XIRR . So for example, first IRR will be calculated from FY21 to FY 22, FY21 to FY 23 . them FY21 to FY24 and goes on and on. Is there a way to achieve this?
So its an expanding calc starting with FY21 and keeps on expanding by brining in additional year.