If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem in Excel
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/comm...ic.excel.setup |
#2
|
|||
|
|||
Problem in Excel
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. Giacomo Amenta wrote: 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/comm...ic.excel.setup -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|