goolam T wrote:
I am using OPENOFFICE.ORG 2.0 Version and I have come across
a disturbing problem bet. OPENOFFICE CALC. & MICROSOFT EXCEL.
Using EXCEL, when I enter “1 Jan 1900”, it gives me the day
as SUNDAY whereas OPENOFFICE CALC returns the day as MONDAY.
Similarly, “31 Jan 1900” with EXCEL is TUESDAY, whereas
OPRENOFFICE CALC it is WEDNESDAY.
I have also tried using the “CHOOSE” Function in both
applications, but with the same result.
The same applies to some other dates as well but not all.
I would be glad to receive your comments.
In Microsoft Excel, days of the week before March 1, 1900 are
incorrect. See this article in the Microsoft Knowledgebase:
http://support.microsoft.com/default.aspx?scid=kb;en-us;214058
--Jean
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
