https://bugs.freedesktop.org/show_bug.cgi?id=74479
mariosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEEDINFO CC| |[email protected] Ever confirmed|0 |1 --- Comment #1 from mariosv <[email protected]> --- Hi @fwiubqpbvuebeqpnEX32nfi3vinkqjfG, thanks for reporting. =WEEKDAY(0;2) = 6 => Saturday Date for 0 is 30/12/1899 => Saturday same result with an empty cell as argument. You need to verify in the SUMPRODUCT() function that the cells are not empty. e.g. B21: =SUMPRODUCT(WEEKDAY($A$20:$A$22;2)=6;NOT(ISBLANK($A$20:$A$22))) For me there is not a bug. -- 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
