Excel having a stab at dates (lemmy.ml)

submitted 1 day ago by [email protected] to c/[email protected]

7 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

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

You need another dragon for Excel and its two date systems.

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

I thought about that, but decided to leave it as an exercise for the reader.

Don’t forget that Integer8 (the middle dragon) counts increments of 100 nanoseconds, because… reasons.

And don’t forget that 1900 still is a leap year in Excel.

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

I don't know what you're trying to do with Excel, but based on your posts, I can only wish you good luck. I'm happy to say that I have been able to outsource low level parsing to third party libraries for my needs so far. Well, except the interpreting semantic formatting part. That was on me.

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

And don’t forget that 1900 still is a leap year in Excel.

Thank you! Saying this finally made me realize why I always need to add/subtract one day when I’m trying to convert dates to and from the Excel representation. 🤦

load more comments (2 replies)

this post was submitted on 01 Jul 2025

57 points (95.2% liked)

Memes

51347 readers

466 users here now

Rules:

Be civil and nice.
Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

founded 6 years ago

MODERATORS

[email protected]