SecondaryMarket Auditors

Is there really a bug with the Excel date function? –

Aug 14, 2004 – 10 posts – ‎1 author

“Actually there is a known (and documented) bug with the Excel date function and it is off by two days, so this date 38106 translates to 5/1/04″

Office solution: Clearing up that wacky date problem when copying …

May 23, 2012 – Sometimes, when you copy a sheet to a new workbook, Excel changes the date. It isn’t abug; you’re dealing with two different date systems.

Year 1900 problem – Wikipedia

The year 1900 problem concerns the misinterpretation of years recorded by only their last two … Microsoft Excel cannot display dates before the year 1900, although this is not … This is for compatibility with Lotus 1-2-3 which also had this bug.

View original post 214 more words


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s