What's the difference between IRR and XIRR?jonadanlee (25) in excel • 7 years ago I use Excel 2010 doing my job. and I wonder what is the difference between IRR and XIRR function. NPV and XNPV functions also are mystery. I asked my colleagues some times but no one could explain it clearly. excel irr xirr npv xnpv