Any Way To Specify XIRR Values and Dates Without Using Array?
Let's say I have a schedule of cash flows and dates that I want to make
calculations of the internal rate of return. But I don't have the data
organized in a way that lets me specify the cell range of the values or the
cell range of the dates. Instead I need to explicitly name individual
cells in the series. Is there a way for me to do this in the XIRR
function? If not, what is a better alternative to XIRR that lets me name
discrete cells for values and dates in the time series?
--
W
|