Monday 6 July, 2009. Statistically significant

I’m sure you’re all aware of the double significance of Monday.  But I thought I’d document it for completeness and for the heathens among you.

Monday 6 July, 2009 will mark the fifth anniversary of this humble little blog.  And it will also be the 40,000th day since the start of the 20th century. *

The latter fact is, of course, significant given that Excel calculates time in days using 1 January, 1900 as its point of reference.  (50,000 will occur on 21 November, 2036, in case you want to book a venue in advance.)

Happy fifth birthday for Monday, little blog.  And happy 40,000th birthday, Excel.

* Actually, Tuesday 7 July, 1900 is the 40,000th day since the start of the 20th century.  But Excel purposely included a bug making 1900 a leap year (it wasn’t; remember?) to comply with other flawed date systems.  So Excel thinks 6 July, 2009 is represented as 40,000, even though it should be 39,999.


Leave a Reply