On Oct 10, 12: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.

Would the following form satisfy your requirements:

=xirr((A8,G8,K8),(B8,H8,L8))

XIRR() seems to be one of the few functions that works with the union
reference operator. See the "About calculation operators" help page.