You could set some helper cells (in a column structure) to the values
of the cells in question, then base the XIRR function on the new
cells. For example, set R1:R3 to the values A8,G8,K8 and S1:S3 to the
values B8,H8,L8.

Mark Lincoln

On Oct 10, 3:23 pm, Lary wrote:
How do you enter the XIRR formula when the numbers and dates are not in the
normal column format structure.

For example, the cash flow numbers are in cells A8,G8,K8 and the dates are
in cells B8,H8,L8.

Thanks in advance for the help