Drawback of Microsoft 1900 Date system.

Today we are going to discuss about the drawbacks of Microsoft 1900 date system.

Microsoft Excel uses two different date systems: the 1900 date system and the 1904 date system. By default Microsoft Excel use the 1900 date system. Microsoft use 1900 date system because the 1900 date system allows greater compatibility between Microsoft Excel and other spreadsheets program such as Lotus 1-2-3.

Drawback of Microsoft 1900 Date system.

The 1900 date system suppose that the year 1900 is a leap year where it is false. due to this every time when we calculate date differences it show 1 day more than actual differences.

Click here for show the actual 1900 calender.
click here for show the Microsoft 1900 date system calendar.


Note:- The 1900 date system suppose that 1st Jan 1900 is the 1 day and the 1904 date system suppose that 1st Jan 1904 is the 1 day. The differences between both date system is 1462 days.