Irr returning really high result.

It should be 7. something no? I'm following a guide and I've inputted the values verbatim. Any ideas? Man they sure made this program a pitb.

Tried to go back to edit to downsize the pic but this is all that was offered. Sorry. Would delete and redo if I could.

Originally Posted by bebo021999

I got 7,6% with my spreadsheet.

Is there any illegal date stored in A column?

Try to use for instance in A1=DATE(2015,ROW(),1), then copy down?

Like this? Thanks.sorry, not too versed in this program.

Originally Posted by bebo021999

In very first post, 1-Jan started from A1? Try to paste the formula in A1, then copy down to A13

If 1-Jan started from other cell, try: =DATE(2015,ROWS($1:1),1) then drag down.

Format cell as dd-mmm

I'm not sure what you're saying with that =date thing. And when I go to format my dates it does not say "dd-mmm" what's mmm anyway? Three letter month like Fed, Mar, Apr? This is what I have now

It doesn't matter how I format my dates. I've tried all possibilities. Same 45%. Thanks anyway

Originally Posted by bebo021999

It may helps a lot if you could upload a sample worksheet.

K, here ya go. Thanks

Originally Posted by bebo021999

A13 is 1-Jan-2015, XIRR returns correct result 45,5%

A13 is 1-Jan-2016, XIRR returns correct result 7,6%

What is your expected result?

Eureka! Thanks! I appreciate your time, the both of you.