https://bugs.documentfoundation.org/show_bug.cgi?id=148747
--- Comment #14 from ady <adylo811...@gmail.com> --- Sorry, sent prematurely. (In reply to ady from comment #13) After spending too-much time with attachment 179794 [details] and re-re-re-reading the posts here, (and also wasting additional time because Calc lacks "Trace dependents" features), I would say that there is no bug here (but, I could be wrong). I tested with LO 7.0.0.3 and with LO 7.4.5. In both, the first column A:A in the first sheet (named "Výpis CZK") is formatted as "D.M.YYYY". In either of these 2 versions the cells in this column are recognized as "DD.MM.YYYY" or anything like that, other than "D.M.YYYY". Moreover, you are using the function CONCAT (for example in sheet "Výpočet 2" column C (e.g in C3) as criterion to compare to the aforementioned "date" cells, which then triggers the SUM in SUMIFS. You probably want some other function such as YEAR(), instead of a text-related function. Anyway, I would suggest checking: https://ask.libreoffice.org/c/czech-and-slovak/13 -- You are receiving this mail because: You are the assignee for the bug.