Re: XIRR/Date Question

From: Jody Goldberg <jody gnome org>
To: Daniel Bigham <daniel_bigham hotmail com>
Cc: gnumeric-list gnome org
Subject: Re: XIRR/Date Question
Date: Thu, 2 May 2002 13:29:59 -0400

On Thu, May 02, 2002 at 05:16:48PM +0000, Daniel Bigham wrote:

My question relates to the dates that this function uses:

p.dates = collect_floats_value (argv[1], ei->pos, COLLECT_DATES, &d_n, 
&result);

(I'm assuming that this line interacts with the spreadsheet)

Any information on these 'double'-formatted dates would greatly be 
appreciated. Are they the number of days since 1900, etc?


Yes.  This represents the day fractions since Jan/1/1900 (and
assuming that 1900 was a leap year :-).  This is well documented in
most MS Excel documentation.

References:
- XIRR/Date Question
  - From: Daniel Bigham

[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]