peterkehle
New Member
- Joined
- Jun 1, 2007
- Messages
- 2
My time frame is 48 months. I have entered the dates in column A rows 1 to 48 and the outflows and inflows in column B rows 1 to 48. There is an outflow in month 1 and month 6 all other months are either positive or are zero.
The dates have been entered as 7/1/2007 for July 1, 2007. Is this correct or a problem?
The cash flows have been entered as a negative number, positive number or zero.
The formula used is =XIRR(B1:B48,A1:A48)
What have I done wrong?
Thanks!
The dates have been entered as 7/1/2007 for July 1, 2007. Is this correct or a problem?
The cash flows have been entered as a negative number, positive number or zero.
The formula used is =XIRR(B1:B48,A1:A48)
What have I done wrong?
Thanks!