this post was submitted on 01 Jul 2025
61 points (95.5% liked)
Memes
51481 readers
437 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
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
You need another dragon for Excel and its two date systems.
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.
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.
”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. 🤦