Question: why does xirr return num?
Answer: error. If you provide an invalid date in the date parameter, the XIRR function will return #NUM! error. Excel tries to recalculate the XIRR until the result is accurate within 0.000001 percent.