XIRR

P

profmorse

Does anyone out there know what time of the day is used for the XIRR
calculation?
 
J

JE McGimpsey

From XL Help ("XIRR"):
• Numbers in dates are truncated to integers.

So all TODs would be midnight, since XL stores times as fractional
values.
 
Top