253
Excel having a stab at dates (sopuli.xyz)
submitted 1 day ago by [email protected] to c/[email protected]
23 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[-] [email protected] 45 points 1 day ago

If you think that's bad, look at what "1" means.

(And, honestly, at least windows' "last big calendar change" and excel's "start of the century when we wrote it" are reasonable points. The unix "let's make it recent so we can fit an absurdly small unit as an integer!" Epoch is just... Weird.)

[-] [email protected] 53 points 1 day ago* (last edited 1 day ago)

“start of the century when we wrote it”

This meme wouldn’t exist had they done that. But they chose the zeroeth, not the first, of January for Excel.

[-] [email protected] 26 points 1 day ago

Yep. "1" is 12:00am on 1-Jan-1900

Numbers less than zero just give a weird error. Between zero and less than one give a nonsense date-formatted non-date.

this post was submitted on 01 Jul 2025
253 points (97.0% liked)

Science Memes

15517 readers
2682 users here now

Welcome to c/science_memes @ Mander.xyz!

A place for majestic STEMLORD peacocking, as well as memes about the realities of working in a lab.

Rules

  1. Don't throw mud. Behave like an intellectual and remember the human.
  2. Keep it rooted (on topic).
  3. No spam.
  4. Infographics welcome, get schooled.

This is a science community. We use the Dawkins definition of meme.

Research Committee

Other Mander Communities

Science and Research

Biology and Life Sciences

Physical Sciences

Humanities and Social Sciences

Practical and Applied Sciences

Memes

Miscellaneous

founded 2 years ago
MODERATORS
[email protected]
[email protected]
[email protected]
[email protected]