Suppose you have values in column A and dates in Column B, then

=XIRR(A1:A10,B1:B10,0.1)

0.1 is the estimated rate.


--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================
"Daniela Gutierrez" wrote in
message ...
Hello

i need to get the xirr

i have this values

-12120
3000
8000
11000

=xirr(all the values, ???)

i dont know what to put in guess and dates,

please help me