Free Republic
Browse · Search
Bloggers & Personal
Topics · Post Article

Skip to comments.

39,000th Day Since Jan 1, 1900.
Excel Spreadsheet | Oct 10, 2006 | Bill Gates

Posted on 10/10/2006 10:27:11 AM PDT by Young Werther

Today I was date stamping a spreadsheet. I was going to use the @ Today function. I entered the function and was about to format the answer. The date functions return the sum of the days since 01/01/1900! Much to my surprise the answer for today was 39,000.


TOPICS: Weird Stuff
KEYWORDS: date; time
So my wife is home visiting Mom! Work's too easy!
1 posted on 10/10/2006 10:27:12 AM PDT by Young Werther
[ Post Reply | Private Reply | View Replies]

To: Young Werther

This earth-shattering discovery really should be in Breaking News.


2 posted on 10/10/2006 10:27:52 AM PDT by Constitution Day (Please do not emanate into the penumbra.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Constitution Day

Series. And hugh.


3 posted on 10/10/2006 10:28:17 AM PDT by Bosco (Remember how you felt on September 11?)
[ Post Reply | Private Reply | To 2 | View Replies]

To: Young Werther

Cool. Time to play the Lotto with multiples of 39.


4 posted on 10/10/2006 10:29:08 AM PDT by FourtySeven (47)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Young Werther

Better let Louie Farrakhan know - he's into that sort of thing.


5 posted on 10/10/2006 10:29:36 AM PDT by 2 Kool 2 Be 4-Gotten
[ Post Reply | Private Reply | To 1 | View Replies]

To: Young Werther

A few seconds ago, it has been 169,516,800 seconds since you signed up to FR
;)


6 posted on 10/10/2006 10:31:49 AM PDT by bwteim (bwteim = Begin With The End In Mind --- Support the Cause: Donate Today)
[ Post Reply | Private Reply | To 1 | View Replies]

To: bwteim
Yeah? Who's countin'

Freaky. I was alive before half of that 39,000 had transpired!! I guess that's why my teenage daughter calls me the "Olde Farte!"

7 posted on 10/10/2006 10:49:38 AM PDT by Young Werther
[ Post Reply | Private Reply | To 6 | View Replies]

To: Young Werther

I remember every one of those 39,000 days. It's been a long, well-remembered life. Please keep me updated!


8 posted on 10/10/2006 10:51:11 AM PDT by Alter Kaker ("Whatever tears one sheds, in the end one always blows one's nose." - Heine)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Young Werther

Today I noticed a funny lump on the side of my right foot.


9 posted on 10/10/2006 10:52:27 AM PDT by Sloth ('It Takes A Village' is problematic when you're raising your child in Sodom.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Young Werther

"my teenage daughter calls me the "Olde Farte!"

LOL. I'm sure she means it with the great respect that is due you;)


10 posted on 10/10/2006 11:14:12 AM PDT by bwteim (bwteim = Begin With The End In Mind --- Support the Cause: Donate Today)
[ Post Reply | Private Reply | To 7 | View Replies]

To: bwteim

She did say that I might be an alternative source of methane. She then asked if I needed more Beano!


11 posted on 10/10/2006 11:38:59 AM PDT by Young Werther
[ Post Reply | Private Reply | To 10 | View Replies]

To: Young Werther

See, not only respectful but intelligent, and watching out for herself, too.


12 posted on 10/10/2006 11:43:27 AM PDT by bwteim (bwteim = Begin With The End In Mind --- Support the Cause: Donate Today)
[ Post Reply | Private Reply | To 11 | View Replies]

To: Young Werther

I hate to break it to you but...

Excel is wrong.

Excel assumes 1900 was a leap year. It wasn't.

Years divisible by 100 are leap years only when they are also divisible by 400. The year 2000 was a leap year - 1900 was not.


13 posted on 10/11/2006 3:37:23 PM PDT by Cheburashka (World's only Spatula City certified spatula repair and maintenance specialist!!!)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Cheburashka

Sooo .. I was born Feb. 29, 1948 ... am I here ... or ain't I?


14 posted on 10/12/2006 3:36:38 AM PDT by knarf (Islamists kill each other ... News wall-to-wall, 24/7 .. don't touch that dial.)
[ Post Reply | Private Reply | To 13 | View Replies]

To: knarf

You are here. 1948 is divisible by 4, but not by 100.

You would not be here if you were born on Feb. 29, 1900.

The bad news is this means you will have to pay your mortgage and your credit card bill this month.


15 posted on 10/12/2006 8:54:15 AM PDT by Cheburashka (World's only Spatula City certified spatula repair and maintenance specialist!!!)
[ Post Reply | Private Reply | To 14 | View Replies]

Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.

Free Republic
Browse · Search
Bloggers & Personal
Topics · Post Article

FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson