I'm calculating an XNPV and I have the values and dates changing, so I've used Address and Match to return the start and end cells for the XNPV calc...

But I'm getting a Value error, and I think it's because the XNPV doesn't recognize what the Address function is returning... Is this right?

Basically, I want the XNPV function to refer back to the cell that Address returns... is that possible?