Answers

Question and Answer:

  Home  MS Excel

⟩ Where can I find some really good information on how excel treats year 2000 dates? I need simple (and that is what u guys provide)?

Any 2 digit dates since January of 1930 will be assumed to be 1930 or after. Microsoft converts an entry of 1/1/30 to be 1/1/1930. (It does the conversion in memory - it may not show it in the spreadsheet)

Any 2 digit dates lower than 12/31/29 are assumed to be 2029 or before.

You can avoid the problem altogether by entering the dates with 4 years. Enter 5/27/1922 to enter a date in 1922, or 5/27/2034 for a date in year 2034

 139 views

More Questions for you: