Dynamic XIRR

[priestren]

Hello and this might be a basic question but please I'm looking for help in how to create a dynamic XIRR with two variables.

For context, I would like the XIRR formula to calculate if the dates change along side the cash flows.

I have the start date going on a monthly basis till the end of the investment horizon (which I have made dynamic) on row 25 starting at column H. The cash flows are right below on row 26 starting at column H and I want to know how to make the XIRR change if the end of my investment horizon changes.

XIRR(OFFSET($H$26,0,$C$24,1,1),OFFSET($H$25,0,$C$24,1,1))

This is the formula I'm using where C24 is the # of periods between the start date and end date and that's linked and dynamic.

Appreciate any help - thanks!

 

[bassplr19]

Perhaps, you want to play with the count(range below H26) instead of using C24