2030 and beyond in Excel

Question

I am starting to plan for the 2030's and noticed if you put in a date that ends in 30 for the year, it is putting 1930 instead of 2030 unless you type it all out, so 12/31/30 becomes 12/31/1930 instead of 2030.&nbsp;&nbsp;

detlef_lewin · Answer

oldakerh&nbsp;That is correct.&nbsp;https://learn.microsoft.com/en-us/office/troubleshoot/excel/two-digit-year-numbers&nbsp;

patrick2788 · Answer

The 1930/2030 suggested change has been submitted here:
https://feedbackportal.microsoft.com/feedback/search/c23f3b77-f01b-ec11-b6e7-0022481f8472?q=2030

A good way to show the Excel team this is important to you is to upvote an existing suggestion and add a comment.

lunchtimeresults · Answer

It seems like the default interpretation for dates ending in "30" is the year 1930 instead of 2030. To avoid this, make sure to explicitly type out the full year (e.g., "2030") to ensure the correct date format. read more here: https://lunchtimeresult.co.za/russia-gosloto-6-45-results/

Forum Discussion

2030 and beyond in Excel

3 Replies

Resources