wr
hn
Top
New
Best
Ask
Show
Jobs
Back
l
linasdev404
Joined 1 month ago
Karma
1
Submissions
1
Member since
Sep 29
View on Hacker News
Recent submissions
Comment · 1 month ago
Adding a month is a footgun even without time zones. I was checking a spreadsheet against another implementation month by month and found that HyperFormula 3.4 returns Feb 28 for EDATE(Jan 31 2028, 1). Excel, Google Sheets and Numbers all return Feb 29, because 2028 is a leap year. Jan 31 + 1 month in a leap year is now a test case in anything I write that does month math.