RealEstateFinance
New Member
- Joined
- Jun 20, 2007
- Messages
- 20
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
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