Re: [office-formula] EOMONTH Function Test Cases (Section 6.9.8)

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

On Sat, 2009-02-21 at 20:19 -0500, robert_weir@us.ibm.com wrote:
> Eric Patterson <ericpa@exchange.microsoft.com> wrote on 02/13/2009 
> 07:55:48 PM:
> 
> > 
> > There seems to be a few typos in the EOMONTH Function test cases. 
> > Specifically:
> > 
> > I believe the expression: =EOMONTH("2000-04-30";-2)=DATE(2006;2;29)
> > should be: =EOMONTH("2000-04-30";-2)=DATE(2000;2;29)
> > 
> > Also, the expression: =EOMONTH("2006-01-05";5)=DATE(2002;6;30
> > should be: =EOMONTH("2006-01-05";5)=DATE(2006;6;30)   <-----Note 
> > missing right Paren as well.
> > 
> > Can someone confirm?
> > 
> > Thanks,
> > Eric
> > 
> 
> That looks right to me.
> 

Rob,

how could this be? According to the draft, the conversion of
"2006-01-05" into a date is implementation defined, so that date could
be May 1st!

Andreas

-- 
Andreas J. Guelzow
Concordia University College of Alberta