Did you know that Microsoft Excel can't do date calculations before January 1, 1900? True. Hasn't been updated since that's the way it was in the MS-DOS first release and original BASIC days. It doesn't do the logical thing and convert the negative values to absolute values and blah blah blah. It just gives you "##################" cells. Weird.
Anyway to deal with the past you have to shift your earliest date to after 01/01/1900 and shift all your other dates forward accordingly, which can introduce errors because 2000 did have a February 29 leap day but normally centuries do not. If you're striving for precision, you'll have to come up with a C++ program or something.
This came up because last week I had a hunch that turned out to be sort of true. The civil war was as long before World War II as we now are from World War II. Roughly.
Actually, August 4 of 2022 will be (+/- a day?) as long after the attack on Pearl Harbor as the attack on Pearl Harbor was after the firing on Fort Sumter.
Showing posts with label war. Show all posts
Showing posts with label war. Show all posts
12/13/2018
5/16/2013
On this date in history: The Texas Navy (!) does some whoopin'
16 May 1843 saw the conclusion of the Naval Battle of Campeche.
Wait, what? The Texans in sailing ships fought British Officers commanding Mexican steamships?
I don't know about you, but the phrase "Texas Navy" stirs my heart. Do you think they had Texas Marines?
Anyway, it was the "First and only time sail bested steam men-of-war!"
Wait, what? The Texans in sailing ships fought British Officers commanding Mexican steamships?
I don't know about you, but the phrase "Texas Navy" stirs my heart. Do you think they had Texas Marines?
Anyway, it was the "First and only time sail bested steam men-of-war!"
Subscribe to:
Posts (Atom)