http://msmvps.com/blogs/robfarley/archive/2009/07/05/excel-dates-counted-differently-and-a-reliable-way-of-working-out-the-day-of-the-week.aspxFollowing my recent post about 40,000 days , I got a couple of emails telling me that Excel disagrees about when the 40,000th day is. And this is true – Excel counts Day 40000 as July 6th 2009, not July 7th. Unfortunately for Excel users, they’re wrongenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://msmvps.com/blogs/robfarley/archive/2009/07/05/excel-dates-counted-differently-and-a-reliable-way-of-working-out-the-day-of-the-week.aspx#1698314Mon, 06 Jul 2009 00:08:01 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1698314Rob Farley<p>Thanks for the links Jimmy &amp; Adrian. I certainly didn&#39;t know that Macs did it differently again! </p> <p>I think all this means that anyone using dates and numbers definitely has to give some thought to the matter.</p> <p>Rob</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1698314" width="1" height="1">http://msmvps.com/blogs/robfarley/archive/2009/07/05/excel-dates-counted-differently-and-a-reliable-way-of-working-out-the-day-of-the-week.aspx#1698310Sun, 05 Jul 2009 23:27:35 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1698310Adrian Downes<p>Good post, Rob.... here&#39;s some fuel to your fire for those who don&#39;t believe that 1900 indeed was NOT a leap year:</p> <p><a rel="nofollow" target="_new" href="http://www.timeanddate.com/date/leapyear.html">www.timeanddate.com/.../leapyear.html</a></p> <p>Best,</p> <p>AD</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1698310" width="1" height="1">http://msmvps.com/blogs/robfarley/archive/2009/07/05/excel-dates-counted-differently-and-a-reliable-way-of-working-out-the-day-of-the-week.aspx#1698187Sun, 05 Jul 2009 12:59:26 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1698187Jimmy May<p>In another challenge related to 1900, the calendars are different in Excel for Mac &amp; PC.</p> <p><a rel="nofollow" target="_new" href="http://support.microsoft.com/kb/214330">support.microsoft.com/.../214330</a></p> <p><a rel="nofollow" target="_new" href="http://support.microsoft.com/kb/180162">support.microsoft.com/.../180162</a></p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1698187" width="1" height="1">http://msmvps.com/blogs/robfarley/archive/2009/07/05/excel-dates-counted-differently-and-a-reliable-way-of-working-out-the-day-of-the-week.aspx#1698180Sun, 05 Jul 2009 12:08:32 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1698180Microsoft and DiscountASP.NET news<p>This is cool...A SQL Server trip through the 1900&#39;s by Rob Farley: 40,000 days since the beginning of</p> <img src="http://msmvps.com/aggbug.aspx?PostID=1698180" width="1" height="1">