Explains why the year 1900 is treated as a leap year in Excel 2000. This article outlines the behaviors that occur if this specific issue is corrected.
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.
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.