XIRR

Definition: The XIRR function in Excel is used to calculate the internal rate of return for a series of cash flows that occur at irregular intervals.

Syntax: ==XIRR(values, dates, [guess]).

Situation: This formula is appropriate in situations where you need to calculate the internal rate of return for a series of cash flows that occur at irregular intervals.

Example: If you have a series of cash flows that occur on January 1, 2022, January 15, 2022, and February 1, 2022, and you want to calculate the internal rate of return for the series of cash flows, you would use the formula =XIRR(A1:A3, B1:B3). This would return a value that represents the internal rate of return for the series of cash flows.