Re: DATE are odd or EVEN

[SUBSCRIBE EXCEL-G Mark Palmer <mark.palmer@AMEY.CO.UK>]

WRONG!!!!
every 4 centuries there are 725 more odd days normally there is only 724.

no idea why except safe to say its leap related.



On Fri, 25 Jul 2003 15:00:40 +0100, Palmer, Mark <Mark.Palmer@AMEY.CO.UK>
wrote:

>there is 725 more odd day than even every century!!!
>
>now that is how slow my Friday is
>
>-----Original Message-----
>From: Larry E. Havard [mailto:LarryH@HAVARD.COM]
>Sent: 25 July 2003 2:45 pm
>To: EXCEL-G@PEACH.EASE.LSOFT.COM
>Subject: Re: DATE are odd or EVEN
>
>
>I was the original poster and here is my take on a slow Friday.
>
>There are more Odd days than Even.  ALL months start with a odd day.  Not
>all month end with a even day.
>
>Because you have months that end in 31 and the new month starts with 1 you
>have 2 odd days.
>You Never have 2 even days in a row therefore logic says there have to be
>more odd days than even
>
>Now you could set up a excel sheet to prove it, but I think the logic is
>sound enough.
>
>
>
>
>Larry E. Havard
>HAVARD
>& ASSOCIATES
>741-B Kenmoor SE
>Grand Rapids, MI 49546
>Voice (616) 458 9333
>Fax    (801) 340 7800
>
>-----Original Message-----
>From: MS Excel General Q & A List [mailto:EXCEL-G@PEACH.EASE.LSOFT.COM] On
>Behalf Of Doug McNutt
>Sent: Friday, July 25, 2003 9:16 AM
>To: EXCEL-G@PEACH.EASE.LSOFT.COM
>Subject: Re: DATE are odd or EVEN
>
>An academic curiosity. Hey, It's Friday. . .
>
>The original poster was clear about wanting the oddness or evenness of the
>day of month but, in a more general sense, are there more odd or more even
>days? In a year? In a month? In a millennium?
>
>After all the number of odd integers is equal to the number of even
>integers, isn't it? Or does that depend on whether the computer uses ones
or
>twos complement arithmetic?
>
>Does the answer depend on the leap year formula?
>
>Dates are curious objects.
>
>--
>-->  There are 10 kinds of people:  those who understand binary, and those
>who don't <--
>
>--------------------------------------------------------------------------
>The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
>international's LISTSERV(R) software.  For subscription/signoff info
>and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
>                             COPYRIGHT INFO:
>http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>
>--------------------------------------------------------------------------
>The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
>international's LISTSERV(R) software.  For subscription/signoff info
>and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
>                             COPYRIGHT INFO:
>http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>
>
>**************************************************************
>CONFIDENTIALITY NOTICE: This email message and
>accompanying data are for the sole use of the intended
>recipient(s) and may contain information that is confidential.
>If you are not the intended recipient, you are notified that
>any use, dissemination, distribution or copying of this
>message or data is prohibited. If you received this email
>message in error, please notify us immediately and erase
>all copies of this message and attachments.
>
>Please note that Amey monitors incoming and outgoing
>mail for compliance with its Email Policy. This will include
>scanning incoming emails to detect viruses.
>
>**************************************************************
>
>--------------------------------------------------------------------------
>The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
>international's LISTSERV(R) software.  For subscription/signoff info
>and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
>                             COPYRIGHT INFO:
>http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G