Enter your cash flows in one column
Enter the corresponding dates in an adjacent column
Use positive values for inflows and negative values for outflows
Select an empty cell for the result
Type the formula `=XIRR(values_range, dates_range)`
Replace `values_range` with the cash flow cells
Replace `dates_range` with the date cells
Press Enter
Format the result cell as Percentage if needed
Ensure the dates are valid Excel dates
Make sure the cash flow ranges have the same number of entries
Include at least one positive cash flow and one negative cash flow