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

[Eike Rathke <erack@sun.com>]

--5G06lTa6Jq83wMTw
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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 missi=
ng or null.  What are the expected results of these expressions?
>=20
>         =3DDATEDIF(DATE(1990;2;15); DATE(1993;9;15); "y")
>         =3DDATEDIF(DATE(1990;2;15); DATE(1993;9;15); "d")
>         =3DDATEDIF(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

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

--5G06lTa6Jq83wMTw
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFJlaP3Zcn5tYf41BIRAhHIAJ9Q6ezjYT1YMJySnmxpDIaTwTZ7cwCfcv1u
fQbNRJC1BfJ/hPPzwf6vI9E=
=wU5s
-----END PGP SIGNATURE-----

--5G06lTa6Jq83wMTw--