Problem in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am scheduling(programming) in Pascal a program for the pupils to know the
day corresponding to a given date. To verify certain day, I made a test on
Excel. There is a problem for the date of 1/1/1900 because that of front are
impossible to obtain. Excel indicates me that 1/1/1900 was Sunday while it
was Monday.
And so I noticed that there was a problem because Excel accepts the date of
February 29th, 1900 while 1900 was a leap year.
Can you do what's necessary to correct this error?
Amenta Giacomo
Belgium

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-ff52be10001c&dg=microsoft.public.excel.setup
 
Excel replicated the Feb 29, 1900 error that was in Lotus 123 for consistency
between the two programs.

If you want to work with dates before 1900, maybe you should create a VBA
procedure. VBA doesn't suffer these same date problems that excel does.
 
Back
Top