Hello and thank you for being a DL contributor. We are changing the login scheme for contributors for simpler login and to better support using multiple devices. Please click here to update your account with a username and password.

Hello. Some features on this site require registration. Please click here to register for free.

Hello and thank you for registering. Please complete the process by verifying your email address. If you can't find the email you can resend it here.

Hello. Some features on this site require a subscription. Please click here to get full access and no ads for $1.99 or less per month.

dates in Microsoft Excel

In less than 5 years, when you input today's date in Excel, you will have to provide a 4-digit year instead of a 2-digit year. Otherwise, it will store it as 1/1/1930 instead of 1/1/2030.

OH THE HUMANITY!!!

by Anonymousreply 4May 6, 2025 11:54 PM

I don't understand. It doesn't confused 2025 with 1925 now, so what happens in 5 years?

by Anonymousreply 1May 6, 2025 11:35 PM

This is why I drink, OP.

by Anonymousreply 2May 6, 2025 11:43 PM

r1, when Y2K came about, Microsoft wanted to allow lazy people an additional 30 years to use 2-digit dates. Any longer than that, and it would be common for people then in their 60s to input 35, for example, to use for their birthdate in 1935, and it would display as 2035 instead. So 30 years seemed to be a good compromise.

by Anonymousreply 3May 6, 2025 11:46 PM

A wave of suicides is predicted when this happens.

by Anonymousreply 4May 6, 2025 11:54 PM
Loading
Need more help? Click Here.

Yes indeed, we too use "cookies." Take a look at our privacy/terms or if you just want to see the damn site without all this bureaucratic nonsense, click ACCEPT. Otherwise, you'll just have to find some other site for your pointless bitchery needs.

×

Become a contributor - post when you want with no ads!