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
Dave Peterson - 05 Oct 2006 19:03 GMT
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.
> 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
[quoted text clipped - 15 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=b7708ff6-21c1-4
656-9b69-ff52be10001c&dg=microsoft.public.excel.setup

Signature
Dave Peterson