RSS Bot@lemmy.bestiver.seMB to Hacker News@lemmy.bestiver.seEnglish · 20 days agoExcel incorrectly assumes that the year 1900 is a leap yearlearn.microsoft.comexternal-linkmessage-square5linkfedilinkarrow-up137arrow-down10file-text
arrow-up137arrow-down1external-linkExcel incorrectly assumes that the year 1900 is a leap yearlearn.microsoft.comRSS Bot@lemmy.bestiver.seMB to Hacker News@lemmy.bestiver.seEnglish · 20 days agomessage-square5linkfedilinkfile-text
minus-squareantlion@lemmy.dbzer0.comlinkfedilinkEnglisharrow-up1·19 days agoAlso for any numeric less than 1 expressed as a date/time will display as January 0, 1900. Because January 1st is day 1. Kind of a shame because they really have an opportunity to support more dates in the past with negative values.
Also for any numeric less than 1 expressed as a date/time will display as January 0, 1900. Because January 1st is day 1. Kind of a shame because they really have an opportunity to support more dates in the past with negative values.