What is XIRR function in Excel? XIRR function is one of Financial functions in Microsoft Excel that returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. To calculate the internal rate of return for a series of periodic cash flows, use the IRR function. Syntax of XIRR function XIRR(values, dates, [guess]) The XIRR…