XIRR function in Excel The Excel XIRR function returns the internal rate of return for a series of cash flows that may or may not be periodic. The function was introduced in Excel 2007 and is available in all later versions of Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Excel for Office 365.