Weird numbers in Excel
Try it yourself
10/23/2015 minus 6/10/1967 = 5/14/1948
10/23/2015 minus 5/14/1948 = 6/10/1967
12/31/2015 minus 10/23/2014 = 70 days
Topics
alignment
Jerusalem Time
Rapture Index Score
Popular Posts
-
Faith and works . Law and grace . This is the age-old battle between God and man-made religion that started not when Martin Luther nai... -
Read the follow-up to this article right here . On August 21, 2017, a total solar eclipse will cross the entire contiguous United St... -
I’m not sure how to convey to you both the seriousness and awesomeness of what may be transpiring in Israel. In short, the Jordania... -
Following the death of a top commander of the Islamic Jihad, Israel has been under a massive rocket barrage from Gaza. Hundreds of rocke... -
Deutsche Sprache | En Español LAST UPDATED: August 8th, 2017. By now you’ve probably heard about what a number of Christians ar... -
This article has suddenly received a large amount of media attention with coverage from The Sun , L.A. Times , Daily Star, Metro , UNILAD, A... -
Greetings brothers and sisters. In lieu of an article we wanted to do a video touching on all that's going on. I pray this blesses yo...
How come a date minus a date gives a date? The reason is that internally, Excel represents a date as just a number. Specifically, Day 1 is 31/12/1899. Logically, it should have been 1/1/1900, but Lotus123 first had a bug which assumed that 1900 was a leap year, so it's off one day as explained here: https://social.msdn.microsoft.com/Forums/office/en-US/f1eef5fe-ef5e-4ab6-9d92-0998d3fa6e14/what-is-story-behind-december-30-1899-as-base-date?forum=accessdev
ReplyDeleteWhat does that mean? That what you found out means that The number of days since the beginning of the 20th century until Sept 23 2015 is the sum of the number of days in the 20th century up to 5/14/1948 and 6/10/1967 resp.
Of course, there is no hard foundation to assume that there is any significance in the number of days in any certain century at all, so it's probably just a freak accident. After all, if you add these two "dates" (rather, date differences to end of 1899), it must come out at /some/ date, and 23/10/2015 is just as good as any.
Mike - I agree. On this blog we consistently point out that many of these things probably have no meaning at all. I thought it curious, especially given some other pointers to October 2015.
ReplyDelete