Dear All,
Requesting assistance to calculate XIRR where the dates and cashflows are derived from another sheet (based on transactions). The ending value and valuation date will depend on the day the XIRR is calculated which is populated separately.
I am attaching the sheet with sample data, would like assist to calculate XIRR. I have been basically trying to insert the ending date and valuation date in the last row using Offset, Indirect etc., but unable to get my head around it.
Bookmarks