Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Fortunately, Excel offers a built-in function, DATEDIF, which makes it easy to calculate elapsed calendar time.