M
machiuyeungsunny
Excel system assign the date 1900/1/1 as day 1. 1900/1/2 as day 2, etc.
I found that the Excel built-in calendar consists of a serious mistake. As
year 1900 is NOT a leap year, it should NOT have the day 1900/2/29. However,
I can actually find that day in the Excel built-in calendar naming it as day
60. The result is all days after 1900/2/29 are one day later than the actual
day. It actually causes great problem when I have to create own VB calendar
functions as all the days are wrong.
Will microsoft correct this problem?
I found that the Excel built-in calendar consists of a serious mistake. As
year 1900 is NOT a leap year, it should NOT have the day 1900/2/29. However,
I can actually find that day in the Excel built-in calendar naming it as day
60. The result is all days after 1900/2/29 are one day later than the actual
day. It actually causes great problem when I have to create own VB calendar
functions as all the days are wrong.
Will microsoft correct this problem?