Date in Excel is Inaccurate

[ewize1]

Do you know that there is no 29 Feb 1900? However, Excel allows you to enter 29 Feb 1900 into a cell without any error. The calendar in Outlook is alright.

I discovered this when I was doing some calculations and found that my result is errorneous. I happened to use 31 Jan 1900 as my reference date, thus 1 Mar 1900 became 30 days after 31 Jan 1900 instead of 29. I guess the simpliest fix to this problem is to change the reference date to one that falls after 29 Feb 1900.

Is this a bug in Excel, which I suppose it should be? I'm using Excel 2003, is there someone who is using the latest version? Maybe you can try to verify this.

Can I use the Outlook calendar in Excel? If yes, how?

Regards.

 

[ewize1]

Some discussion about this issue can be found in the following thread:

http://www.mrexcel.com/board2/viewtopic.php?t=235673

 

[Richard Schollar]

It doesn't affect VBA (even if executed from within Excel) - 29/2/1900 doesn't exist in VBA. It is an interesting oddity which DougT explained very well.

Richard