• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

XIRR with cashflow starting on different dates


New Member
Hi guys, I hope somebody could help me with this. I put together the attached file with XIRR at the bottom, however I have about 100 more asset cash flows to add to this. My question is how can I key in a XIRR formula that wouldn't require me to manually select the date range targeting when the cash flow starts and ends. I would like a formula that I could drag over and it will automatically calculate the XIRR for the rest of the asset cash flows.

Please HELP :)


  • XIRR sample.xlsx
    15.1 KB · Views: 3