This is one of reasons, I NEVER use date formats with 2-digit year! I prefer to decide myself, into which century the date belongs!
Changing the way Windows interprets 2-year format dates is only moving your current problem to some other workbook (or to any other program), where you need to enter a date from past year.
|