XIRR values dates estimated_irr Parameters or Arguments values A range of cells that represent the series of cash flows. There should be cash outflow and inflow. Next in order to calculate XIRR you need to use below formula.
Di the ith or last payment date.
G9 The answer will be 489. The function will calculate the Internal Rate of Return IRR for a series of cash flows that may not be periodic. In order to do this enter two series in your formula. XIRR Function XIRR function calculates the Internal Rate of Return for a supplied series of cash flows.