RE: [office-formula] DATEDIF (Section 6.9.2)

[Eric Patterson <ericpa@exchange.microsoft.com>]

Excel also produces 3, 1308 and 212.

-Eric

-----Original Message-----
From: Eike.Rathke@sun.com [mailto:Eike.Rathke@sun.com] On Behalf Of Eike Rathke
Sent: Friday, February 13, 2009 8:47 AM
To: office-formula@lists.oasis-open.org
Subject: Re: [office-formula] DATEDIF (Section 6.9.2)

Hi Eric,

On Friday, 2009-02-13 01:32:42 +0000, Eric Patterson wrote:

> Three of the test cases for DATEDIF() show the expected result as a missing or null.  What are the expected results of these expressions?
>
>         =DATEDIF(DATE(1990;2;15); DATE(1993;9;15); "y")
>         =DATEDIF(DATE(1990;2;15); DATE(1993;9;15); "d")
>         =DATEDIF(DATE(1990;2;15); DATE(1993;9;15); "yd")

Not sure, Calc doesn't have the DATEDIF() function.
Gnumeric gives 3, 1308 and 212.
I can't check right now, what does Excel produce as a result?

  Eike

--
Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.