In MS Excel, the XIRR calculation formula is `=XIRR(values, dates),` where “values” are the cash flows and “dates” are the corresponding dates of those cash flows.