Re: Date Error in MS Works

new topic     » goto parent     » topic index » view thread      » older message » newer message 

------=_NextPart_000_000F_01BF7CB0.9AE8CE60
        charset="iso-8859-1"

1900 wasn't a leap year, but an old, old spreadsheet that ran under MSDOS
called Lotus 123 thought that it was a leap year.  When Microsoft got into
the spreadsheet market, they continued the error for the sake of backward
compatibility.  Nice, huh?

FYI, the leap year rule is:
    TRUE if the year's evenly divisible by 400 else
    FALSE if the year's evenly divisible by 100 else
    TRUE if the year's evenly divisible by 4 else
    FALSE

Joe

-----Original Message-----
From: Euphoria Programming for MS-DOS
[mailto:EUPHORIA at LISTSERV.MUOHIO.EDU]On Behalf Of Joel Crook
Sent: Monday, February 21, 2000 9:46 AM
To: EUPHORIA at LISTSERV.MUOHIO.EDU
Subject: Re: Date Error in MS Works


yep... Excel will allow you to enter 2/29/1900. Curiously, if you enter
=datevalue(02/29/1900) it returns "60" which is the number of days from the
start of the Excel calendar. 3/1/1900 returns 61. So 1900 was a leap year...
right?



At 02:19 PM 02/16/2000 +1300, you wrote:
>I have just sent some code to Rob for placement on the Contributions page.
>It will convert a date to an integer & vice versa. While trying to check my
>earlier attempts at these functions I noticed that my version of MS Works
>4.0 (spreadsheet) will allow 29/2/1900 (that's 2/29/1900 in US) to be a
>valid date. I was just wondering if the same thing happens in MS Excel.
>Anyone?
>
>Yours Truly
>Mike
>
>vulcan at win.co.nz

Joel H. Crook

Manager, Information Services
Certified Novell Administrator
Microsoft Certified Professional, OS Specialist

Kellogg & Andelson Accountancy Corp.
14724 Ventura Blvd. 2nd Floor
Sherman Oaks, CA 91403
(818) 971-5100


------=_NextPart_000_000F_01BF7CB0.9AE8CE60
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D200180403-22022000>1900=20
wasn't a leap year, but an old, old spreadsheet that ran under MSDOS =
called=20
Lotus 123 thought that it was a leap year.&nbsp; When Microsoft got into =
the=20
spreadsheet market, they continued the error for the sake of backward=20
compatibility.&nbsp; Nice, huh?</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D200180403-22022000>FYI,=20
the leap year rule is:</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D200180403-22022000>&nbsp;&nbsp;&nbsp; TRUE if the year's evenly =
divisible=20
by 400 else</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D200180403-22022000></SPAN></FONT><FONT color=3D#0000ff =
face=3DArial=20
size=3D2><SPAN class=3D200180403-22022000>&nbsp;&nbsp;&nbsp; FALSE if =
the year's=20
evenly divisible by 100 else</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D200180403-22022000></SPAN></FONT><FONT color=3D#0000ff =
face=3DArial=20
size=3D2><SPAN class=3D200180403-22022000>&nbsp;&nbsp;&nbsp; TRUE if the =
year's=20
evenly divisible by 4 else</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D200180403-22022000>&nbsp;&nbsp;&nbsp; FALSE</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Euphoria Programming =
for=20
MS-DOS [mailto:EUPHORIA at LISTSERV.MUOHIO.EDU]<B>On Behalf Of </B>Joel=20
Crook<BR><B>Sent:</B> Monday, February 21, 2000 9:46 AM<BR><B>To:</B>=20
EUPHORIA at LISTSERV.MUOHIO.EDU<BR><B>Subject:</B> Re: Date Error in MS=20
Works<BR><BR></FONT></DIV>
<DIV>yep... Excel will allow you to enter 2/29/1900. Curiously, if you =
enter=20
=3Ddatevalue(02/29/1900) it returns "60" which is the number of days =
from the=20
start of the Excel calendar. 3/1/1900 returns 61. So 1900 was a leap =
year...=20
right?</DIV><BR><BR>
<DIV>At 02:19 PM 02/16/2000 +1300, you wrote:</DIV>
<DIV>&gt;I have just sent some code to Rob for placement on the =
Contributions=20
page.</DIV>
<DIV>&gt;It will convert a date to an integer &amp; vice versa. While =
trying to=20
check my</DIV>
<DIV>&gt;earlier attempts at these functions I noticed that my version =
of MS=20
Works</DIV>
<DIV>&gt;4.0 (spreadsheet) will allow 29/2/1900 (that's 2/29/1900 in US) =
to be=20
a</DIV>
<DIV>&gt;valid date. I was just wondering if the same thing happens in =
MS=20
Excel.</DIV>
<DIV>&gt;Anyone?</DIV>
<DIV>&gt;</DIV>
<DIV>&gt;Yours Truly</DIV>
<DIV>&gt;Mike</DIV>
<DIV>&gt;</DIV>
<DIV>&gt;vulcan at win.co.nz</DIV><BR>Joel H. Crook<BR><BR>Manager, =
Information=20
Services<BR><FONT size=3D1>Certified Novell Administrator<BR>Microsoft =
Certified=20
Professional, OS Specialist<BR><BR></FONT><B>Kellogg &amp; Andelson =
Accountancy=20
Corp.<BR></B><FONT size=3D1>14724 Ventura Blvd. 2nd Floor<BR>Sherman =
Oaks, CA=20

------=_NextPart_000_000F_01BF7CB0.9AE8CE60--

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu