DATEVALUE seems to behave better ...
Err:502 =DATEVALUE(9/27/2005) <-- Invalid argument
38622 =DATEVALUE("9/27/05")
38591 =EDATE("9/27/05";-1)
-30 =EDATE(9/27/2005;-1)
0.5 =YEARFRAC("1.1.2002"; "7.1.2002";1)
0.00 =YEARFRAC(1/1/2002;7/10/2002;1)
On 9/28/05, David Chapman <[EMAIL PROTECTED]> wrote:
> Paul,
>
> I agree with your assessment / concerns. I have not checked if there
> are similar issues with other date functions.
>
> Dave
>
> On 9/28/05, Paul Smith <[EMAIL PROTECTED]> wrote:
> > Dear All
> >
> > If one uses, in Calc, the wrong syntax
> >
> > WEEKDAY(09/27/2005)
> >
> > (without the quotes), one gets 7 as result. This may be misleading, as
> > one may assume that this result is correct. Therefore, I think that a
> > error should be given when the quotes are forgotten. Do you agree with
> > this comment?
> >
> > Regards,
> >
> > Paul
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> --
> My OpenOffice Calc Website
> http://www.openofficetips.com
>
--
My OpenOffice Calc Website
http://www.openofficetips.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
