Excel (even the latest rev, although I don't use that one...I'm on 2003) won't correctly calculate min values for dates beyond 12/31/29.
Create a column of 6 dates (say a1:a6)........all nearer than 12/31/29.

Then, in another column, create a cell with =min(a1:a6).
It will correctly return the date closest to now.
You can put in any dates you want up to 12/31/29 and it will return the value correctly.
Then type in a date beyond 2029.......say 4/4/30. Excel thinks it's 1930. Thus, it returns the wrong answer.
I've tried formatting as xx/xx/xxxx and entering in the same fashion. Still errs.
My brother is running the latest version of Office 365 and it fails on his version as well.

Any thoughts, folks? Sure seems odd that it can't correctly manipulate a date only 12 years away. Hopefully, there is a setting somewhere that can rectify this odd condition.

oh........and I did try using both the 1900 and the 1904 date systems.......no change re this issue.

Hi and welcome
one should think that MS has thought about that..
And in fact, they did
https://support.office.com/en-us/art...e-d4707bc9fb9f
Google (can be ) your friend...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Brilliant Picoflyer!


I was trying to set a flag in Excel........it never occurred to me to do it in the OS....


Absolutely outstanding........thank you for your help

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.