XNPV Function

Get the Net Present Value (NPV) for a series of cash flows that may not be periodic. XNPV uses specific dates that correspond to each cash flow being discounted in the series, whereas the regular NPV Function automatically assumes all the time period...