I have a report with records in the detail that show a dollar amount in one field and a date in another field. I am trying to calculate the XIRR of the range of numbers to get an annual average return. The XIRR formula asks for the actual dates and numbers rather than the field references. Can anyone help me with this issue?