FINANCE.XNPV(rate, amounts..., dates...)
Calculates the net present value for a schedule of cash flows. The amounts and dates parameters must be the same length.
The first amount should correspond to the first date, and so on.
rate: Discount rate of the investment over one period.
amounts: List of the income or payments for the investment.
dates: List of the dates corresponding to the income or payment amounts.
FINANCE.XNPV(0.1, amount1, amount2, amount3, date1, date2, date3)