NPV Calculation with Specific End Date?

[RealEstateFinance]

Experts:

I have a row of over a hundred dates and with a corresponding dollar amount below each date. Is there a way I can craft an NPV formula that will return a value for values up to a certain date. I.e., if the dates are in cells B1:B105, the values are in C1:C105, the "target date" is hardcoded in cell D1 & the NPV calculation is in cell E1 and it is inclusive of all the dates & values in rows B & C - but calculates only through my specified date in cell D1?

Thanks in advance.

REF

 

[Andrew Poulsom]

Like this?

=NPV(rate,C1:INDEX(C1:C105,MATCH(D1,B1:B105,FALSE)))

 

[RealEstateFinance]

Andrew,

Your approach works. Thanks for helping me out.


REF