XNPV Calc that Adjusts if the Dates and Amounts Change

[deli9680]

I have a stream of cash flows and corresponding dates that I am calculating an XNPV for... I have the model fully automated to a few inputs can change everything...

However, I can't get the XNPV calculation to automatically change it's parameters as the cash flows and dates change... Is there anyway to do this?

Basically, I'm trying to find a way to have the XNPV function search for the first and last date with a cash flow and reset itself to calculate for those new cash flows.

[MarvinP]

Hi deli,

I'm not sure how your data is set up but this feels like a job for Dynamic Named Ranges (DNR).
http://www.ozgrid.com/Excel/DynamicRanges.htm or
http://www.contextures.com/xlNames01.html or
http://www.bettersolutions.com/excel...G820716330.htm

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-form...ts-change.html

Thread Closed.