Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / October 2006

Tip: Looking for answers? Try searching our database.

Problem in Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Giacomo Amenta - 05 Oct 2006 18:09 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.