- Search ExcelTip.com
directly from Excel
- Get immediate access to the
"Tip of the Hour"
- View hundreds of Microsoft
Excel tips with a click of a button
- Absolutely
Free - Click
here to download
Make your Amazon.com purchases by clicking the graphic below
|
Excel Tip .com - Mailing List Thread Index
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: DATE are odd or EVEN
I can't fault that logic - "there are more odd days than even", but I still
find that very odd.
Aside from midnight (GMT), it is always an odd day somewhere. ;)
We call someone 'Odd', few are called even.
Oddfellows are large round mintie sweets.
Regards Robert
"yes I know"
----- Original Message -----
From: "Larry E. Havard" <LarryH@HAVARD.COM>
To: <EXCEL-G@PEACH.EASE.LSOFT.COM>
Sent: Saturday, July 26, 2003 1:44 AM
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
|
And at your local bookseller


Excel Training Level I
Excel
Training Level II
Excel
Training Level III
Excel
VBA Training Level I
Excel
VBA Training Level II
View All Excel Training Programs

Formula Manager
Duplication
Manager
Text
Manager
Number
Manager
Add-ins
Collection
Spreadsheet
Assistant
Number
Manager
Add-ins
Collection
Spreadsheet
Assistant
View All Excel Add-Ins
|