https://bugs.freedesktop.org/show_bug.cgi?id=74479
--- Comment #2 from fwiubqpbvuebeqpnex32nfi3vinkq...@lazyinbox.com --- (In reply to comment #1) > 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. Hi! Thanks for the fast reply. You are right that the result is correct if the selection is ok. This is my case (A) in the example. If you followed cases (B) and (C) in the example, you see there is something wrong. Because results are even fine on Monday, Tuesday, Wednesday, Thursday, Friday and Sunday when the selection(s) contain empty cells, but why not for Saturdays? In older LibreOffice versions i had really a problem, because i needed to select Saturdays of hundreds of cells and it gives me wrong results even when the selection was ok. So for me it is a small bug. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs