To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46137 Issue #:|46137 Summary:|Date function not working correctly Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|ui Assigned to:|spreadsheet Reported by:|pcreytens
------- Additional comments from [EMAIL PROTECTED] Mon Mar 28 01:36:58 -0800 2005 ------- Opened a blank OO Calc sheet and did the following: Cell E6 = 'January 1, 2005' (date formatted cell) Formula in cell E7: =DATE(YEAR(E6);MONTH(E6)+1;DAY(0)) & formatted as date should be IMO 'February 1, 2005' In OO: shows 'March 2, 2005' In Microsoft Excel 2000: shows 'January 31, 2005' --------------------------------------------------------------------- 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]