roi and irr

Job ID: 33523585

Budget: $15 – $25 USD

I need a formula to calculate for ROI AND IIR
I have a start date for initial investment received - I then have a date that part of initial investment was returned - then I have a date where all investment has been returned then I have a final date where profit is paid out.
Related categories: Excel VBA Excel Macros