Hello,
I want to calculate XIRR but challenge is that i have four text criteria as well as i have capital invested date, dividend date, capital return date and Market value date and values for all four are in different columns.
I have use XIRR(INDEX(indirect))) which is gives me correct answerer but if all date are in same column then only it works fine ..
I want formula in yellow highlighted cell, theoretical answerer I have written just beside yellow highlighted cell - Pl go through the excel sheet attached.
Any expert pl help ASAP.......
I want to calculate XIRR but challenge is that i have four text criteria as well as i have capital invested date, dividend date, capital return date and Market value date and values for all four are in different columns.
I have use XIRR(INDEX(indirect))) which is gives me correct answerer but if all date are in same column then only it works fine ..
I want formula in yellow highlighted cell, theoretical answerer I have written just beside yellow highlighted cell - Pl go through the excel sheet attached.
Any expert pl help ASAP.......