To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91072
------- Additional comments from [EMAIL PROTECTED] Fri Jul 18 17:04:05 +0000 2008 ------- A function to calculate Easter Sunday which is compatible with both openoffice.org calc and Microsoft Excel, without requiring a macro, is to be found here: http://www.probabilityof.com/excel.shtml#25 The function is =FLOOR(DATE(YearRef;5;DAY(MINUTE(YearRef/38)/2+56));7;1)-34 Where YearRef is the cell containing the year. If the year is in row 3 (absolute) of the same column as the formula, useful syntax is to replace YearRef by INDIRECT(ADDRESS(3;COLUMN();2) (the parameter "2" makes the reference apply to the relative column, but absolute row) --------------------------------------------------------------------- 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]
