To calculate XIRR, enter details of all SIP purchases and the current value or the redemption value along with the date in the Excel columns. Make sure the dates are on the left side, while the ...