OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


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


On Fri, 2009-02-13 at 18:27 +0100, Eike Rathke wrote:
> Hi Eric,
> 
> On Friday, 2009-02-13 17:12:11 +0000, Eric Patterson wrote:
> 
> > Excel also produces 3, 1308 and 212.
> 
> Thanks, noted down in my TODO list.

I think the real problem here is that the so called "definition" doesn't
really define the behaviour:

=DATEDIF(DATE(1992;2;15); DATE(1993;9;15); "d")

Are we counting days here in 1992 (a leap year) or in 1993 (not a leap
year)?

Andreas

-- 
Andreas J. Guelzow, PhD, FTICA
Coordinator, Mathematical & Computing Sciences
Concordia University College of Alberta



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]