I attempted to calculated the XIRR from a dataset (please see the sample sheet linked below). However, on two occasions, the XIRR formula returns two different errors:
"XIRR attempted to compute the internal rate of return for a series of cash flows, but it was not able to."
"Function XIRR parameter 1 expects number values. But '' is a text and cannot be coerced to a number."
The errors can be found on the two respective tabs. I've checked that all $ values in the dataset are numbers and all dates are dates. Any insights into how to get the XIRR to calculate correctly is appreciated. Thank you!
You have blank dates in Cells
B557
,B593
[tab_Error 2], which I now filled with some random dates (enter valid dates OR consider disregarding them from formula calculation) as XIRR needs valid dates alongside the cashflow amounts in Column_A. its no longer throwing an error