office-formula message

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

From: Eric Patterson <ericpa@exchange.microsoft.com>
To: "office-formula@lists.oasis-open.org"<office-formula@lists.oasis-open.org>
Date: Fri, 13 Feb 2009 01:32:42 +0000

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")

Thanks,
Eric Patterson

Follow-Ups:
- [office-formula] DAY (Section 6.9.4)
  - From: Eric Patterson <ericpa@exchange.microsoft.com>
- Re: [office-formula] DATEDIF (Section 6.9.2)
  - From: Eike Rathke <erack@sun.com>