ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - XIRR (https://www.excelbanter.com/excel-discussion-misc-queries/144757-xirr.html)

profmorse

XIRR

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

JE McGimpsey

XIRR

From XL Help ("XIRR"):

€¢ Numbers in dates are truncated to integers.

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

In article ,
profmorse wrote:

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

All times are GMT +1. The time now is 05:39 PM.