https://bugs.freedesktop.org/show_bug.cgi?id=57402
mariosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC| |[email protected] --- Comment #1 from mariosv <[email protected]> --- The 3.6 versions are more strict about text conversion into numbers/dates. In your formula: =WEEKDAY(CONCATENATE(TEXT(A9;"##");".";C$4;". ";TEXT(C$3;"####"))) ^ there is an extra space after second point. Works well without the space: =WEEKDAY(CONCATENATE(TEXT(A9;"##");".";C$4;".";TEXT(C$3;"####"))) But I think the formula can be more simple and avoid errors: =WEEKDAY(DATE(C$3;C$4;A9)) Change status: Resolved NotaBug If you are not agree, please reset the status to Unconfirmed. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
