To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46137
------- Additional comments from [EMAIL PROTECTED] Tue Apr 12 06:02:08 -0700 2005 ------- Seems that you try to use the DATE function in a wrong way: Why do you use DAY(0) or DAY(1) at all? 0 and 1 are no dates in your case, but already the values for the day, so =DATE(YEAR(E6);MONTH(E6)+1;1) should exactly do what you want (in Calc and Excel). The DAY function is used to extract the day from a complete date. Now for the different behaviour of DAY(1) in Calc and Excel: Yes, Excel contains a "bug" here, it is in there for years and intended to keep compatibility to Lotus, see http://www.j-walk.com/ss/excel/odd/odd02.htm. Calc does not do this, it correctly assumes that 1900 is no leap year. So, Excel thinks that the value 1 is the date 1900-Jan-01, while Calc uses the value 1 for the date 1899-Dec-31. With this, dates are equal in Calc and Excel starting at 1900-Mar-01. It follows also that Excel thinks that DAY(1) is 1, but Calc thinks that DAY(1) is 31. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
