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.
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.