Re: [office-formula] EDATE Function Test Cases (Section 6.9.7)

[Andreas J Guelzow <aguelzow@math.concordia.ab.ca>]

On Sat, 2009-02-14 at 00:47 +0000, Eric Patterson wrote:
> There seems to be a few typos in the EDATE Function test cases.  Specifically:
> 
> I believe the expression: =EDATE("2000-04-30";-2)=DATE(2006;2;29)
> should be: =EDATE("2000-04-30";-2)=DATE(2000;2;29)
> 
> Also, the expression: =EDATE("2000-04-05";24)=DATE(2002;4;12)
> should be: =EDATE("2000-04-05";24)=DATE(2002;4;5)
> 
> Can someone confirm?

We should not have test cases that involve implementation defined
conversions.
=EDATE("2000-04-30";-2)=DATE(2006;2;29)
should be
=EDATE(DATE(2000;4;30);-2)=DATE(2000;2;29)

Andreas

-- 
Andreas J. Guelzow
Concordia University College of Alberta