There's at least a 3 problems with your worksheet:
1. For an XIRR function, the years on row 3 must be dates (e.g. 1/1/2010), not just numbers (e.g. 2010) as you now have.
2. You must have at least one -ve and one +ve value. As yet, you only have +ve values.
3. Since your dates are evidently periodic, you should be using the IRR function, which would also free you from the need for true dates on row 3.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|