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.