XIRR Calculation on date range

[Rsaiq]

Hi All,

I have a requirement to calculate XIRR on date range as select by user.

In short, In our requirement Opening and Closing is changing as per user selection for XIRR Calculations.

Please guide me for resolving this issue.

Kindly find attached Sample file data.

Thanks.