The Difference Between the Date Systemsīecause the two date systems use different starting days, the same date is represented by different serial numbers in each date system. However, Excel for Macintosh now defaults to the 1900 date system and supports dates as early as January 1, 1900.įor more information, see Excel incorrectly assumes that the year 1900 is a leap year. In the past, Excel for Macintosh defaulted to using the 1904 date system for workbooks originating on a Macintosh. This design was intended to prevent problems related to the fact that 1900 was not a leap year. For example, if you enter July 5, 1998, Excel converts the date to the serial number 34519.īecause of the design of early Macintosh computers, dates before January 1, 1904, were not supported. When you enter a date, the date is converted into a serial number that represents the number of elapsed days since January 1, 1904, starting with 0 for January 1, 1904. In the 1904 date system, the first day that is supported is January 1, 1904. The 1900 date system enables better compatibility between Excel and other spreadsheet programs, such as Lotus 1-2-3, that are designed to run under MS-DOS or Microsoft Windows. For example, if you enter July 5, 1998, Excel converts the date to the serial number 35981.īy default, Microsoft Excel for Windows uses the 1900 date system. When you enter a date, the date is converted into a serial number that represents the number of elapsed days starting with 1 for January 1, 1900. In the 1900 date system, the first day that is supported is January 1, 1900. This article describes the two date systems and the problems that you may encounter when you use workbooks that use different date systems. These systems are the 1900 date system and the 1904 date system. Microsoft Excel supports two different date systems. For more information about this change, read this blog post. Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise.
0 kommentar(er)
