Next, in the IRR function, in the Values field, select the array of cells that contains the values of the payments and receipts for which you want to calculate the IRR. In our example, it is A1:A13.

IRR cannot handle this and will give erroneous results, but XIRR can do the job. The XIRR function can be found using the command fx and under the category ‘Financial’.