Function Type: Financial
Description:
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
Function Structure:
=XIRR(values, date, [guess]).
Argument Breakdown:
values – This is the array of values that represent the series of cash flows. Instead of an array, it can be a reference to a range of cells containing values.
date – This is a series of dates that correspond to the given values. Subsequent dates should be later than the first date, as the first date is the start date and subsequent dates are future dates of outgoing payments or income.
guess – This is an initial guess – or estimate – of what the IRR will be. If omitted, Excel takes the default value of 10%.
Example:

If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.