XIRR Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
XIRR(table, values, dates, [guess])
table – A table for which the values and dates expressions should be calculated.
values – An expression that returns the cash flow value for each row of the table.
dates – An expression that returns the cash flow date for each row of the table.
guess – (Optional) An initial guess for the internal rate of return. If omitted, the default guess of 0.1 is used.
Internal rate of return for the given inputs. If the calculation fails to return a valid result, an error is returned.