I searched a lot, but couldn’t find the right solution;
specs: libreoffice Version: 18.104.22.168 / Build ID: 420m0(Build:1) / Dutch / Ubuntu 13.10
In Calc I have a cell with a date value, which I format to show in which quarter it fell. Next I have to compare this value of the cell in a sum.if-function to a text-cell but I can’t figure out how to compare them to get a TRUE-result.
The value of the cell is e.g. 01-01-2014, which is shown as “1ste kwartaal” (Dutch for “1st quarter”) by formating this cell with a date format of “QQ”. This cell, with the generated “1ste kwartaal” value, has to be compared with a cell with the text-value “1ste kwartaal” and the only outcome i get is FALSE…
Does anybody know how it’s done?