Syntax: XNPV(R, V, D)
R = discount rate to apply to the cash flows
V = a range containing a series of cash flows
D = a range containing the dates of cash flows in V
XNPV returns the net present value for a series of cash flows (V) with variable intervals (D). V and D must be one-dimensional ranges and have the same size.
XNPV(9.00%, B1..B5, A1..A5) = 705.1677
Excel function: N/A