Re: Date Error in MS Works

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

--=====================_1874867==_.ALT


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

--=====================_1874867==_.ALT

<html><div>yep... Excel will allow you to enter 2/29/1900. Curiously, if
you enter =datevalue(02/29/1900) it returns &quot;60&quot; 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?</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 page.</div>
<div>&gt;It will convert a date to an integer &amp; vice versa. While
trying to check my</div>
<div>&gt;earlier attempts at these functions I noticed that my version of
MS Works</div>
<div>&gt;4.0 (spreadsheet) will allow 29/2/1900 (that's 2/29/1900 in US)
to be a</div>
<div>&gt;valid date. I was just wondering if the same thing happens in MS
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 Services<br>
<font size=1>Certified Novell Administrator<br>
Microsoft Certified Professional, OS Specialist<br>
<br>
</font><b>Kellogg &amp; Andelson Accountancy Corp.<br>
</b><font size=1>14724 Ventura Blvd. 2nd Floor<br>
Sherman Oaks, CA 91403<br>
(818) 971-5100<br>
</font></html>

--=====================_1874867==_.ALT--

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

Search



Quick Links

User menu

Not signed in.

Misc Menu