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.