Passage of History

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. 

No comments:

Post a Comment

Thanks for taking the time to leave a comment. Please note that it may take a while to turn the handle of the Crowndot moderation mill and spit out your comment.