Date in Excel is Inaccurate

ewize1

Board Regular
Joined
Nov 3, 2003
Messages
121
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.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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
 

Forum statistics

Threads
1,136,345
Messages
5,675,219
Members
419,553
Latest member
hanahass

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top