Entering Dates after 2030
I'm entering dates going out to 2032, and when I enter dates like 10/1/32, Excel is changing the date to 1932. Excel should be defaulting to 2032 like it does for dates in the 2020's.
Sergei Baklan makes an awfully useful point.
Sergei Baklan commented
That's not Excel, that's Windows. Go to your regional setting (Win+R and type 'control international'), Additional settings, Date, and here you may change the range for two-digits year interpretation. By default it is between 1930 and 2029.